Re: [sqlite] Full Table Read

2009-02-16 Thread Nathan Biggs
= >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nathan Biggs >> Subject: Re: [sqlite] Full Table Read >> >> We are actually using Windows XP for an OS. (I know, lots of >> limitations, but that is what we have to u

Re: [sqlite] Full Table Read

2009-02-16 Thread Griggs, Donald
lite.org] On Behalf Of Nathan Biggs > Subject: Re: [sqlite] Full Table Read > > We are actually using Windows XP for an OS. (I know, lots of > limitations, but that is what we have to use). > > = > > I think the windows equivalent would

Re: [sqlite] Full Table Read

2009-02-16 Thread Alexey Pechnikov
Hello! В сообщении от Monday 16 February 2009 17:18:04 Nathan Biggs написал(а): > Is that just creating an in-memory database then?  I'm not familiar with > a copy to a null location. Writes to in-memory database is not saved to disk. If you only want to increase read speed when ram-cache of

Re: [sqlite] Full Table Read

2009-02-16 Thread Nathan Biggs
== > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nathan Biggs > Subject: Re: [sqlite] Full Table Read > > We are actually using Windows XP for an OS. (I know, lots of > limitations, but that is what we ha

Re: [sqlite] Full Table Read

2009-02-16 Thread Griggs, Donald
> On linux you can do > dd if=database.db of=/dev/null bs=1M > and after perform "select ..." = From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nathan Biggs Subject: Re: [sqlite] Full Table Read We

Re: [sqlite] Full Table Read

2009-02-16 Thread Nathan Biggs
We are actually using Windows XP for an OS. (I know, lots of limitations, but that is what we have to use). Alexey Pechnikov wrote: > Hello! > > В сообщении от Saturday 14 February 2009 00:33:38 Nathan Biggs написал(а): > >> Is there a faster way to read an entire table other then: >> >>

Re: [sqlite] Full Table Read

2009-02-14 Thread Alexey Pechnikov
Hello! В сообщении от Saturday 14 February 2009 00:33:38 Nathan Biggs написал(а): > Is there a faster way to read an entire table other then: > > select * from table > > Not that is is slow, just curious. On linux you can do dd if=database.db of=/dev/null bs=1M and after perform "select ..."

Re: [sqlite] Full Table Read

2009-02-13 Thread Kees Nuyt
On Fri, 13 Feb 2009 16:33:38 -0500, Nathan Biggs wrote in General Discussion of SQLite Database : >Is there a faster way to read an entire table other then: > >select * from table; It is the fastest SQL way. >Not that is is slow, just curious. The

[sqlite] Full Table Read

2009-02-13 Thread Nathan Biggs
Is there a faster way to read an entire table other then: select * from table Not that is is slow, just curious. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users