If I access other pages in my application ,it works fine. Its only this page with query given that's causing problem.I also tried running the query from sqlite studio query editor. It beahves the same . So I think its Sqlite and not the webserver.
-----Original Message----- From: sqlite-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 not the WebServer? Do you have an index on Events.NotificationTime ? --- On Tue, 5/5/09, Kalyani Phadke <kpha...@deltacontrols.com> wrote: > From: Kalyani Phadke <kpha...@deltacontrols.com> > Subject: [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, EventClassRef, TransitionTime, Message, > MonitoredRef, EventRef,ToState,Priority,Acked from Events WHERE > Events.NotificationTime >= {ts '2009-05-04 14:44:10'} Order By ID > DESC LIMIT 100 > > If I run my application once the query returns results in 80 sec and > if run it again , memory usage starts growing and reaches nearly 100% > ..then I get more hard page faults , the application responds slow, or > system just hangs. I am running my application on Windows web server > 2008 with 512 MB RAM. How can I optimize the query ? I have indexes on > ID and notificationtime (datatype timestamp) > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
