Brief overview of Recordset convertor performance.
|Recordset convertor performance test|
| Areas>ASP>Performance tests|
Recordset converter performance test - configuration- P200, 128MB RAM
- Win NT 4.0 SP5
- SQL 6.5 SP5
- IIS 4
- MDAC 2.1 SP2
- SQL server on the same machine as IIS
Tested objects.Data Source for all of the tests was ADODB recordset, data from ODBC connection to SQL 6.5. The connection was created by DSN :
Three source VBS codes were tested to get consumed procesor time and script time. All of these three codes (DBF, MDB and CSV) create output file in one row of source code :Set Conn = CreateObject("ADODB.Connection") Conn.Open "DSN=TestDSN(ODBC To SQL6.5);", "uid", "pwd" SQL = "Set rowcount ... Select * From TestTable(Nolock) Set rowcount 0" Set ADORS = Conn.execute(SQL)
1. Recordset converter, DBF object :
Set DBF = CreateObject("RSConvert.DBF") Response.BinaryWrite DBF.GetFile(ADORS)
2. Recordset converter, MDB object :
3. GetString method of ADO recordset to see reference time (or minimal time to retrieve data from database) :Set MDB = CreateObject("RSConvert.MDB") Response.BinaryWrite MDB.GetFile(ADORS)
Script time and consumed timesNext tables contain measured script and processor time for different kind of source data structure and different number of rows. Table header contains brief characterization of source data table structure.
Results.The times give you a small overview of Recordset converter performance. The test configuration was poor, so real times (for example on PIII/600 instead of P/200) will be up to 5 times better.
The consumed time depends linearly on number of rows/columns. The number of rows is limited only by time dedicated to the file generation. But there is no good idea to generate binary files greater than 50MB in ASP. You can use Recordset converter to distribute DBF and MDB data with up to 10 000 rows or up to 1MB of output binary data in real-time (time of second).
DBF does not support large text data - you can use MDB to do the work. MDB has good performance to distribute large text data.
4) Script time - TickCount [ms] of the operation. The time has two parts - Kernel+User time of calling thread and execution time of all other processes.
Script Time contains also Kernel+User time of SQL server and Kernel+User time of IIS.
5) Kernel+User time - times of calling thread in [ms]
|See also for:Recordset convertor performance test|
Recordset converter is a library for converting DAO or ADO recordsets to MDB or DBF files. It enables direct binary output of MDB or DBF files from ASP pages with one row of code. The object also supports on-the-fly compression by zip/arj.
© 1996 - 2009 Antonin Foller, Motobit Software | About, Contacts | e-mail: firstname.lastname@example.org