Regarding: "... when a query is issued, does SQLite cache the results, so that future queries can be processed off the cache (I think not) "
Hi Uma, In effect, powerful caching effects *do* occur because of the disk cache provided by modern operating systems. Since the hard disk operations are typically orders of magnitude longer than the sql engine's cpu work for a query, the fact that the disk sectors required by a recent query tend to hang around a bit makes for very efficient use of RAM memory -- probably much better for the system as a whole than if sqlite tried to reserve all this ram for itself. For some applications, it even makes sense to perform a command-line copy of the entire sqlite database to a NUL device, since this will pre-load the operating system cache. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------