On Sat, Jan 13, 2007 at 12:57:43AM -0500, [EMAIL PROTECTED] wrote: > The SQLite database > is INSERTed into because I want to keep historical data. The rationale > for this is explained later.
For your main application (finding the least loaded machine) you don't need historical data, so put the historical data in a separate table or else add a column that you'll set to NULL for historical data and which will be part of an index/primary key so that historical data is not indexed. And since you have so few "live" rows you might as well just have two tables and for the non-historical table don't even bother with indexes. Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
