On Tue, May 15, 2007 at 01:17:40PM +0200, TiNo wrote:
> now it makes a query for every photo in
> the DB. Right now that would only be a couple thousand (3 I think), but that
> could be more than 10 thousand in a couple of years. Would this slow things
> really down with a SQLite db?
Yes, I think so.
> And if so, is there another way to do this?
Do it SQL-wise. Recreate and declare the intermediate table, and do a
join.
> Another question bubbles up. Is there a way to create a dict out of a
> SelectResult?
Starting with 0.8 SQLObject.sqlmeta has a method .asDict().
> Or a JSONifiable object?
No, that's completely outside of the scope of SQLObject.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
