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 :
1. Recordset converter, DBF object :
2. Recordset converter, MDB object :
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 decided 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]
for 'Recordset convertor performance test' articleBest way to get HTML page from a recordsetPerformance tests of six different VBS codes, each of them generates the same HTML table.
ASP/VBS database performance test and comparison.ADO, DAO, RDO, MDB, SQL, OLEDB and ODBC comparison, performance test of objects that can be used for database access on server-side in ASP.
Copyright and use this code
The source code on this page and other samples at https://www.motobit.com/tips/ are a free code, you can use it as you want: copy it, modify it, use it in your products, ...
If you use this code, please:
1. Leave the author note in the source.
2. Link this sample from you page.
<A Href="https://www.motobit.com/tips/detpg_rsctest/" Title="Recordset convertor is great object which enables direct output of binary database data from ASP page as DBF/MDB." >Recordset convertor performance test</A>
Do you like it? Rate me on LinkedIn
© 1996 - 2019 Antonin Foller, Motobit Software | About, Contacts