Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Virgilio Alexandre Fornazin
:25 To: General Discussion of SQLite Database Subject: Re: [sqlite] Large SQLite3 Database Memory Usage I am using SQLite ODBC Driver. How can I find if its leak in my provider??? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Kalyani Phadke
Database' Subject: Re: [sqlite] Large SQLite3 Database Memory Usage Are you using ADO or plain sqlite dll ? May this be a leak in your provider ? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kalyani Phadke Sent: terça-feira

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Virgilio Alexandre Fornazin
Subject: Re: [sqlite] Large SQLite3 Database Memory Usage I am running the query with CursorLocation = 2, CursorType = 2, LockType = 3 to handle 610MB database with 2259207 records in table. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Kalyani Phadke
, 2009 11:45 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Large SQLite3 Database Memory Usage How much RAM is needed to handle 610MB database with 2259207 records in table.Initially I was running Windows web server 2008 with 512 MB RAM,now I upgraded to 1GB RAM but still

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Kalyani Phadke
To: General Discussion of SQLite Database Subject: Re: [sqlite] Large SQLite3 Database Memory Usage Thanks for your response. The query runs faster than mine but still facing problem after running the page multiple times.So I think I should try with 1GB of RAM. Thanks, -Original Message- From

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Kalyani Phadke
Of BareFeet Sent: Tuesday, May 05, 2009 9:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Large SQLite3 Database Memory Usage Hi Kalyani, > I have 2259207 records in table using SQLite3 database. I am running > the select query to retrive records from DB > > SELECT ID, Ev

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Kalyani Phadke
-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ken Sent: Tuesday, May 05, 2009 10:18 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Large SQLite3 Database Memory Usage Upgrade your ram. Are you sure its sqlite using all the memory

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Ken
ct: [sqlite] Large SQLite3 Database Memory Usage > To: sqlite-users@sqlite.org > Date: Tuesday, May 5, 2009, 11:36 AM > I have 2259207 records in table using > SQLite3 database. I am running the > select query to retrive records from DB > > SELECT ID, EventClassName, E

Re: [sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread BareFeet
Hi Kalyani, > I have 2259207 records in table using SQLite3 database. I am running > the > select query to retrive records from DB > > SELECT ID, EventClassName, EventClassRef, TransitionTime, Message, > MonitoredRef, EventRef,ToState,Priority,Acked from Events WHERE > Events.NotificationTime

[sqlite] Large SQLite3 Database Memory Usage

2009-05-05 Thread Kalyani Phadke
I have 2259207 records in table using SQLite3 database. I am running the select query to retrive records from DB SELECT ID, EventClassName, EventClassRef, TransitionTime, Message, MonitoredRef, EventRef,ToState,Priority,Acked from Events WHERE Events.NotificationTime >= {ts '2009-05-04