Hi All, We are using libdbi in OpenBSC to access the sqlite database and we have experienced some performance issues. I have tested a very simple query like "SELECT * from SMS where id = NR" and I did so with dbi and with storing the query inside a text file and send executing cat file | sqlite3 db. libdbi is many many times slower than the simple setup.
I have started to look into the DBI interface, also wrote a SystemTap probe to see which statements are executed and I see that PRAGMA table_info is executed for each column. For my testcase simply caching the last result of the PRAGMA is giving me an almost 4x times improvement. Should I create a bug report and attach the patches I have come up with so far. The code is still slower than using sqlite3 directly, is anyone else working on figuring out why this is the case? regards holger ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
