Hi Joe,
I have configured the sqlite in the following mode (see below), and performance
marginally improved from 2500 records/sec to 8000/sec.
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.
regards
ragha
Compile Options:
./configure --enable-threadsafe
Makefile:
#BCC = gcc -g -O2
BCC = gcc -O2
# C Compile and options for use in building executables that
# will run on the target platform. (BCC and TCC are usually the
# same unless your are cross-compiling.)
#
#TCC = gcc -g -O2 -I. -I${TOP}/src
TCC = gcc -O2 -I. -I${TOP}/src
# Define -DNDEBUG to compile without debugging (i.e., for production usage)
# Omitting the define will cause extra debugging code to be inserted and
# includes extra comments when "EXPLAIN stmt" is used.
#
TCC += -DNDEBUG=1 -DSQLITE_DEFAULT_CACHE_SIZE=32768
-DSQLITE_DEFAULT_PAGE_SIZE=8192 -DSQLITE_DEFAULT_TEMP_CACHE_SIZE=32768
-DTEMP_STORE=3
******************************************************************************************
This email and its attachments contain confidential information from HUAWEI,
which is intended only for the person or entity whose address is listed above.
Any use of the information contained herein in any way (including, but not
limited to, total or partial disclosure, reproduction, or dissemination) by
persons other than the intended recipient(s) is prohibited. If you receive this
e-mail in error, please notify the sender by phone or email immediately and
delete it!
*****************************************************************************************
----- Original Message -----
From: RaghavendraK 70574 <[EMAIL PROTECTED]>
Date: Tuesday, June 26, 2007 10:30 pm
Subject: Re: [sqlite] In Mem Query Performance
> Ok.
> Will notify u once i complete the test.
>
> regards
> ragha
>
> ******************************************************************************************
> This email and its attachments contain confidential information
> from HUAWEI, which is intended only for the person or entity whose
> address is listed above. Any use of the information contained
> herein in any way (including, but not limited to, total or partial
> disclosure, reproduction, or dissemination) by persons other than
> the intended recipient(s) is prohibited. If you receive this e-mail
> in error, please notify the sender by phone or email immediately
> and delete it!
>
> *****************************************************************************************
> ----- Original Message -----
> From: Joe Wilson <[EMAIL PROTECTED]>
> Date: Wednesday, June 27, 2007 0:48 am
> Subject: Re: [sqlite] In Mem Query Performance
>
> > :memory: databases only have a page size of 1024.
> >
> > Try various page_size settings for a file based database file and
> > see what happens.
> >
> > I have no other suggestions.
> >
> > --- RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
> > > It is a server platform,Linux SuSE9 enterpraise edition.
> > > 4 CPU machine,8GB ram.
> > > We want load all the tables in to mem db of Sqlite.Achieve
> > > read performance of upto 50000records/sec for the table data i
> > had mentioned earlier.
> > >
> > > "so it would have to be file based."
> > > I could not get it. Does it mean even increasing the page size
> > there would be
> > > no effect on the performance?
> >
> >
> >
> >
> >
> ____________________________________________________________________________________>
> It's here! Your new message!
> > Get new email alerts with the free Yahoo! Toolbar.
> > http://tools.search.yahoo.com/toolbar/features/mail/
> >
> > ------------------------------------------------------------------
> -
> > ----------
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > ------------------------------------------------------------------
> -
> > ----------
> >
> >
>
> --------------------------------------------------------------------
> ---------
> To unsubscribe, send email to [EMAIL PROTECTED]
> --------------------------------------------------------------------
> ---------
>
>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
