SQL Joins

The below fully describes the JOIN concepts in sql.

Alternative for PHP_excel

Alternative for PHP_excel which can "Export to XLSX/XLS" file in a customized format

For Writing Excel

• PEAR's PHP_Excel_Writer (xls only)
• php_writeexcel from Bettina Attack (xls only)
• XLS File Generator commercial and xls only
• Excel Writer for PHP from Sourceforge (spreadsheetML only)
• Ilia Alshanetsky's Excel extension (xls only, and requires commercial component)
• PHP's COM extension (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)
• The Open Office alternative to COM (PUNO) (requires Open Office installed on the server with Java support enabled)
• PHP-Export-Data by Eli Dickinson (Writes SpreadsheetML - the Excel 2003 XML format, and CSV)
• Oliver Schwarz's php-excel (SpreadsheetML)
• Oliver Schwarz's original version of php-excel (SpreadsheetML)
• excel_xml (SpreadsheetML, despite its name)

For Reading Excel

• php-spreadsheetreader reads a variety of formats (.xls, .ods AND .csv)
• PHP-ExcelReader (xls only)
• PHP_Excel_Reader (xls only)
• PHP_Excel_Reader2 (xls only)
• XLS File Reader Commercial and xls only
• PHP Excel Explorer Commercial and xls only
• Ilia Alshanetsky's Excel extension (xls only, and requires commercial component)
• PHP's COM extension (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)
• The Open Office alternative to COM (PUNO) (requires Open Office installed on the server with Java support enabled)

All are faster than PHPExcel, but (with the exception of COM and PUNO) they don't offer both reading and writing, or both xls and xlsx; may no longer be supported; and (while I haven't tested Ilia's extension) only COM and PUNO offers the same degree of control over the created workbook.

Stress Testing

Recently we made a lot of research on Stress Testing tools to test our server/application capability . Finally our team has choose JMeter.
JMeter is simple and powerful tool for Load Testing. Main advantage is its open source and very simple to learn.
We used JMeter to test asp.net application.