--- RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > I have configured the sqlite in the following mode (see below), and > performance > marginally improved from 2500 records/sec to 8000/sec.
1.05 times faster is marginal. Three times faster is quite good. Try compiling sqlite library using the sqlite3.c amalgamation: http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation with these flags: -O3 -fomit-frame-pointer > Pls help,if anything else need to be done to get at least 30000records/sec > with each column being 128Bytes,10 column table,10000 records. Make sure you're using sqlite 3.4.0 and run VACUUM and ANALYZE on the database prior to querying. A 30M database (with indexes I'm guessing) is tiny. Something may be wrong with your schema, index, or key column design. Make sure your database file and temp store is on a local disk and not on the network. Post a typical SELECT statement and the output of EXPLAIN QUERY PLAN SELECT ... ____________________________________________________________________________________ Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. http://autos.yahoo.com/green_center/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
