Re: #entries in APSW statement cache
Roger Binns <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ed Pasma wrote: > In a test where the speed is compared, Could you post or mail me the speed test? I always like that sort of code since it helps with profiling etc. > match very well. It appears that this is due to the fact that the > test includes more different SQL statements than what fits in the > APSW statement cache. The statement cache should end up with the most used statements. Do real world programs really have that many different "hot" statements? DRH has also claimed that SQLite is really fast at compiling statements. That is why I sized the statement cache at 32. > Could this be increased to 100 as in pysqlite? Done. > Or could you make the number of entries in the cache configurable? Yes, I have put in a ticket for this and will do it before the next release. (The only thing remaining for the next release is ripping out all the stuff to do with threading). Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHWbAtmOOfHg372QQRAng8AJ9GnCivLjG6VEKpIAtLbrWofR3lyQCffVzG 44ACfPuh8loY80fTlOisO2g= =mpVp -----END PGP SIGNATURE-----