: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 Of
QLite 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: t
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
, 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 the
: 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
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
qlite-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 and no
Upgrade your ram.
Are you sure its sqlite using all the memory and not the WebServer?
Do you have an index on Events.NotificationTime ?
--- On Tue, 5/5/09, Kalyani Phadke wrote:
> From: Kalyani Phadke
> Subject: [sqlite] Large SQLite3 Database Memory Usage
> To: sqlite-users@s
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 >
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 14:44:10'
10 matches
Mail list logo