Hi Nicolas, Thanks for the reply. My database is fixed in the number of tables and fields. I mean Schema cannot be altered once it is created. But the database records might grow even more than 20K in number. I have tried select query with and without indexes. Selection without indexes is very costly. Hence I don't think we can omit indexes.
-----Original Message----- From: Nicolas Williams [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 8:47 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Query on database operations. On Thu, Nov 30, 2006 at 08:03:00PM +0530, Kalyani Tummala wrote: > With indexes on every column(searched), the following is the heap size > for different database operations on a database with 100 records and 6 > tables with an avg of 10 to 15 fields each. You can probably get by quite well without indexes on such small databases. Dropping the indexes should lead to simpler compiled queries, and that hopefully to less heap usage (certainly less page cache usage). Nico -- ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] ********************************************************************** ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------