On 16/11/2011, Juha Manninen <juh....> wrote: > > This is interesting because often the DB queries are the slowest part of a > (web-)application.
For our applications, setting up the DB connection is the slowest part, not the actual queries. Our queries execute in 1-3 milliseconds. As for a text file as database, compared to a real RDBMS server... text files are *way slower*! The tiOPF project has persistence layers for text files (TAB, CSV and XML) and SQL database servers. I attached the hourly Speed Timing unit test report. As you can see, querying TAB, CSV and XML are by magnitudes slower than any RDBMS backend. quick example: table iteration (selection of records) for TAB vs SqlDB_Interbase..... 19056ms vs 452ms -- Regards, - Graeme - _______________________________________________ fpGUI - a cross-platform Free Pascal GUI toolkit http://fpgui.sourceforge.net
[Free Pascal CSV] TableTestIterationCount=15586.00 TotalTestTime=2.00 CreateTable=0.00 DropTableTable=0.00 ReadMetaData=0.00 RowTestIterationCount=6190.00 InsertRow=0.00 UpdateRow=0.00 DeleteRow=0.00 [Free Pascal FBL] TableTestIterationCount=440.00 TotalTestTime=2.00 CreateTable=1.00 DropTableTable=1.00 ReadMetaData=0.00 RowTestIterationCount=1859.00 InsertRow=0.00 UpdateRow=0.00 DeleteRow=0.00 [Free Pascal Sqldb_IB] TableTestIterationCount=452.00 TotalTestTime=2.00 CreateTable=1.00 DropTableTable=1.00 ReadMetaData=0.00 RowTestIterationCount=1579.00 InsertRow=0.00 UpdateRow=0.00 DeleteRow=0.00 [Free Pascal TAB] TableTestIterationCount=19056.00 TotalTestTime=2.00 CreateTable=0.00 DropTableTable=0.00 ReadMetaData=0.00 RowTestIterationCount=7320.00 InsertRow=0.00 UpdateRow=0.00 DeleteRow=0.00 [Free Pascal XMLLight] TableTestIterationCount=9962.00 TotalTestTime=2.00 CreateTable=0.00 DropTableTable=0.00 ReadMetaData=0.00 RowTestIterationCount=6763.00 InsertRow=0.00 UpdateRow=0.00 DeleteRow=0.00
-- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
