Re: creating tables needed for a query on-demand
Roger Binns <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ryan Blazecka wrote: > yes, I realize my use case is a little bit strange. ;) I'm just trying > to get lazy evaluation for my results, so I do work only if the user is > actually going to make use of the data. the population step is by far > the biggest bottleneck, so all of my efforts are on reducing that. It sounds to me that virtual tables would be a far better solution for you. You can the heavy lifting only as data is needed. PySQLite doesn't have virtual tables yet, but apsw does. See http://www.rogerbinns.com/apsw.html#VirtualTables Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFx58kmOOfHg372QQRAk5UAKCbLXwjCu9xASbqBgY7MrEw5A/FNACguoxf IXNzfZK6h3Xz0o+xY/diLVc= =GmOD -----END PGP SIGNATURE-----