[sqlite] Running a select on multiple servers.

search on multiple databases. Once you get the row, the modification can be done to that specific machine very easily by the higher end code, but the multiple database search has to be handled at the lower end in C. Thanks in advance. -- :: Ligesh :: http://ligesh.com

[sqlite] Re: sqite2.8 performance snag when filesize growsmore than 70MB on a 256MB ram

On Mon, Aug 22, 2005 at 08:44:07AM +0800, Damian Slee wrote: > >>In order to implement the ORDER BY clause, SQLite reads the entire result > >>set into memory and sorts it there. When your result set gets very large > >>(13000 rows) and each row uses in excess of 1KB or memory,this is >

[sqlite] Re: sqite2.8 performance snag when filesize grows more than 70MB on a 256MB ram

On Sat, Aug 20, 2005 at 06:36:19PM -0400, D. Richard Hipp wrote: > On Sun, 2005-08-21 at 03:21 +0530, Ligesh wrote: > > I am running a very simple sql query with only one instance. The > > query is something like: > > > > select * from table where parent_name = '

[sqlite] Re: sqite2.8 performance snag when filesize grows more than 70MB on a 256MB ram

On Sat, Aug 20, 2005 at 06:36:19PM -0400, D. Richard Hipp wrote: > On Sun, 2005-08-21 at 03:21 +0530, Ligesh wrote: > > I am running a very simple sql query with only one instance. The > > query is something like: > > > > > > In order to implement the ORDER BY

[sqlite] Re: sqite2.8 performance snag when filesize grows more than 70MB on a 256MB ram

On Sun, Aug 21, 2005 at 12:30:25AM +0200, Ulrik Petersen wrote: > Ligesh, > > Ligesh wrote: > > >I am running a very simple sql query with only one instance. The query is > >something like: > > > >select * from table where parent_name = 'parent' order by

[sqlite] Re: sqite2.8 performance snag when filesize grows more than 70MB on a 256MB ram

1KB per row. Is this some known problem? Can anyone shed some light on this? Thanks in advance. - Ligesh

[sqlite] The total when using LIMIT clause

Hi, How do we know the total number of results, when we are using LIMIT? is there any parameter that returns the real number of matches? Thanks in advance. -- :: Ligesh