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

On Sun, 2005-08-21 at 04:24 +0530, Ligesh wrote: > On Sun, Aug 21, 2005 at 12:30:25AM +0200, Ulrik Petersen wrote: > > > > > >select * from table where parent_name = 'parent' order by name limit 10 > > > > I am running on linux, and I will need this to scale to at least > 200,000 rows If you

Re: [sqlite] Why can i open a textfile?

I agree, since that makes error/exception handling easier. On the subject of open(), I also would like it to have a read_only option, if that is possible. I am not even sure that a read-only state is tracked through the library, or if the writing attempts just fail with an file access error.

[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 = 'parent' order by name limit > >

[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 clause, SQLite reads the > entire

[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 name limit 10 > > > > > > My guess

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

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 = 'parent' order by name limit > 10 > > The query takes around .3 seconds when the total number of matches >

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

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 name limit 10 My guess (and it is only a guess) is that, because of the ORDER BY clause, SQLite is loading all rows

Re: [sqlite] Why can i open a textfile?

On Aug 20, 2005, at 1:38 PM, D. Richard Hipp wrote: There might be a bug. If SQLite sees a file that is less than 1024 bytes in length, it might assume (mistakenly) that it is empty and then overwrite it. I'll have to check on that. If it does, this should be considered a bug. Ok. It

Re: [sqlite] Why can i open a textfile?

On Aug 20, 2005, at 1:38 PM, D. Richard Hipp wrote: There might be a bug. If SQLite sees a file that is less than 1024 bytes in length, it might assume (mistakenly) that it is empty and then overwrite it. I'll have to check on that. If it does, this should be considered a bug. Yes. That

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

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 name limit 10 The query takes around .3 seconds when the total number of matches are around 7,000, but just jumps to 11 seconds, at 13,000

Re: [sqlite] Why can i open a textfile?

On Sat, 2005-08-20 at 13:36 -0700, Will Leshner wrote: > On Aug 20, 2005, at 9:21 AM, D. Richard Hipp wrote: > > > SQLite never "blows away" a file that is not a database. > > Sorry to use such crude language :) But I believe I have run into an > issue with SQLite reformatting a non-sqlite

Re: [sqlite] Why can i open a textfile?

On Aug 20, 2005, at 11:33 AM, Edwin Knoppert wrote: Oops.. good bye simple telephone list! I just added a table and the list is replaced by an sqlite db. Right. That's what I thought. The wrapper I develop is very careful to check to make sure a file is really a SQLite database before

Re: [sqlite] Why can i open a textfile?

On Aug 20, 2005, at 9:21 AM, D. Richard Hipp wrote: SQLite never "blows away" a file that is not a database. Sorry to use such crude language :) But I believe I have run into an issue with SQLite reformatting a non-sqlite file as a SQLite database. I will try to reconstruct the problem

Re: [sqlite] Why can i open a textfile?

Oops.. good bye simple telephone list! I just added a table and the list is replaced by an sqlite db. - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Saturday, August 20, 2005 6:21 PM Subject: Re: [sqlite] Why can i open a

Re: [sqlite] Why can i open a textfile?

This does not result in an error but returns the fields (no records of course): SELECT * FROM sqlite_master where [type]='table' - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Saturday, August 20, 2005 6:21 PM Subject: Re:

Re: [sqlite] Why can i open a textfile?

I could do a simple test myself of course, like checking the master or so.. - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Saturday, August 20, 2005 6:21 PM Subject: Re: [sqlite] Why can i open a textfile? On Sat, 2005-08-20 at

Re: [sqlite] Why can i open a textfile?

I ever read the suggestion to read in the db myself and check for a signature. Well, if i strongly suggest an extra test is done by the system itself. Sure if 0 bytes it's a go as well, as it is now but if > 0 bytes.. test.. I see no point in opening the database while other commands will fail.

Re: [sqlite] Why can i open a textfile?

On Sat, 2005-08-20 at 09:06 -0700, Will Leshner wrote: > On Aug 20, 2005, at 1:25 AM, Edwin Knoppert wrote: > > > v3.2.1, i opened a textfile containing a simple list not related to > > sqlite. > > Was testing my error handler but it still opens it. > > > > Do you mean you called sqlite3_open?

Re: [sqlite] Why can i open a textfile?

On Aug 20, 2005, at 1:25 AM, Edwin Knoppert wrote: v3.2.1, i opened a textfile containing a simple list not related to sqlite. Was testing my error handler but it still opens it. Do you mean you called sqlite3_open? I believe sqlite3_open does not yet test to see if the database is truly

Re: [sqlite] SQLite3 Explorer dates

This would be more effective if it were also available for MacOS and Linux. -ken On 20-Aug-05, at 5:32 AM, Ralf Junker wrote: Hello Clark Christensen, SQLiteSpy executes the query "select date('2005-08-19');" with no problems. SQLiteSpy is a free SQLite3 database manager and is similar

Re: [sqlite] Convert / Import

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Griggs, Donald wrote: > -Original Message- > From: administrator [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 16, 2005 5:01 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Convert / Import > > > Does anybody know a good/quick way

Re: [sqlite] SQLite3 Explorer dates

well, yes, it IS a limitation, which I will fix in the next release. the problem is, EXP registers its own version of a "date" function, as described in the readme (I think I did describe it :), which is completely different than the standard sqlite3 date function. I will make this optional in the

Re: [sqlite] SQLite3 Explorer dates

Hello Clark Christensen, SQLiteSpy executes the query "select date('2005-08-19');" with no problems. SQLiteSpy is a free SQLite3 database manager and is similar to EXP. To testdrive SQLiteSpy, download your copy from http://www.yunqa.de/delphi/sqlitespy/ Regards, Ralf >If appropriate for