[Lazarus] Web development and XML database (Mattias)

[Graeme Geldenhuys]

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
-------------- next part --------------
[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