On Feb 9, 2006, at 8:05 PM, Mike Orr wrote:
There are 6000
chemicals with 200 fields each, so I'm not sure I want the entire
objects in memory. I need only the ID and name (for hyperlinks in
TurboGears).
Hey Mike,
I'm curious about how you might be dealing with larger data sets
where you don't want every single value from the database cached in
an object somewhere.
For my domain objects, the numbers are fairly reasonable so I just
use SQLObject straight up the way it was intended to be used. But,
with my *event* tables that record various user events within the
system, the tables are 1 to 2 million rows and counting. For these,
I'm using the _connection.queryAll and _connection.queryOne methods
within some home grown helper classes.
I'm not sure that there is a programmatic solution within SQLObject
for tables with many, many, many rows, is there? Does anyone out
there have any experience dealing with tables of this size within
SQLObject?
--T
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
