Re: [sqlite] Version 3.1.0

2005-01-23 Thread sganz
The one aspect that I find usefull is for accessing a larger memory space. For example on your typical linux (rh9 32bit) you start to run out of mem (per process) at about 2gig. I can immediatly take the app an run on a 64bit machine and get at least an additional gig of ram from the allocators.

Re: [sqlite] Version 3.1.0

2005-01-22 Thread Clay Dowling
Robert L Cochran wrote: 1. My wife, on her 32 bit Intel laptop, running Microsoft Access, finds her system slowed down to a crawl whenever she works with one table that has 109,000 rows. This is just the beginning of the huge tables she creates. She has a bunch of others. I moved this table to

Re: [sqlite] Version 3.1.0

2005-01-22 Thread Robert L Cochran
Yes -- this is what I'm talking about. Bob Roger Binns wrote: I think all this discussion has missed the original question. Quite simply, is there any way in which the SQLite *source code* could be changed in order to get better performance on 64 bit machines. If there is then following

[sqlite] Version 3.1.0

2005-01-21 Thread D. Richard Hipp
Version 3.1.0 (alpha) of SQLite is now available on the website. Release notes are available from a link on the homepage. This released is labeled alpha but it is still very well tested. By being alpha it means that there is still a small window of opportunity during when users can suggest API

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Cory Nelson
Any API changes? On Fri, 21 Jan 2005 13:33:35 -0500, D. Richard Hipp [EMAIL PROTECTED] wrote: Version 3.1.0 (alpha) of SQLite is now available on the website. Release notes are available from a link on the homepage. This released is labeled alpha but it is still very well tested. By being

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Eli Burke
D. Richard Hipp wrote: This released is labeled alpha but it is still very well tested. By being alpha it means that there is still a small window of opportunity during when users can suggest API changes. Once we go to beta (in about a week) no more changes will be accepted. So if you want to

Re: [sqlite] Version 3.1.0 API suggestion: sqlite3_commit()

2005-01-21 Thread Eric Scouten
D. Richard Hipp wrote: This released is labeled alpha but it is still very well tested. By being alpha it means that there is still a small window of opportunity during when users can suggest API changes. Once we go to beta (in about a week) no more changes will be accepted. So if you want to

AW: [sqlite] Version 3.1.0

2005-01-21 Thread Michael Ruck
of all sqlite...16() functions. - Michael -Ursprüngliche Nachricht- Von: D. Richard Hipp [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 21. Januar 2005 19:34 An: sqlite-users@sqlite.org Betreff: [sqlite] Version 3.1.0 Version 3.1.0 (alpha) of SQLite is now available on the website

Re: [sqlite] Version 3.1.0 API suggestion: sqlite3_commit()

2005-01-21 Thread Ulrik Petersen
Eric, Eric Scouten wrote: D. Richard Hipp wrote: This released is labeled alpha but it is still very well tested. By being alpha it means that there is still a small window of opportunity during when users can suggest API changes. Once we go to beta (in about a week) no more changes will be

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Doug Currie
Friday, January 21, 2005, 1:33:35 PM, DRH wrote: Version 3.1.0 (alpha) of SQLite is now available on the website. Compiling with MinGW MSYS on WinXP... 1. I had to modify my lib/tclConfig.sh to have TCL_LIB_SPEC='-L/mingw/lib -ltcl84' instead of TCL_LIB_SPEC='' or else testfixture wouldn't

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Raymond Irving
Hi, It would be nice if Autovacum can be set for a database with data and also be set to occur at timely intervals. Maybe something like every 1000 updates or deletes. __ Raymond Irving --- D. Richard Hipp [EMAIL PROTECTED] wrote: Version 3.1.0 (alpha) of SQLite is now available on the

Re: AW: [sqlite] Version 3.1.0

2005-01-21 Thread Tom
] Version 3.1.0 Version 3.1.0 (alpha) of SQLite is now available on the website. Release notes are available from a link on the homepage. This released is labeled alpha but it is still very well tested. By being alpha it means that there is still a small window of opportunity during when users can

Re: [sqlite] Version 3.1.0 API suggestion: sqlite3_commit()

2005-01-21 Thread Eric Scouten
Ulrik Petersen wrote: Eric, Eric Scouten wrote: D. Richard Hipp wrote: This released is labeled alpha but it is still very well tested. By being alpha it means that there is still a small window of opportunity during when users can suggest API changes. Once we go to beta (in about a week) no

Fw: [sqlite] Version 3.1.0 API suggestion: autovacuum

2005-01-21 Thread =?iso-8859-1?Q?Miguel_Angel_Latorre_D=EDaz?=
What if the autovacuum feature could be set based on a percent (pragma autovacuum_percent?) of the unused file size (if known) ? It could be useful to specify the fullness of data/keys of pages (pragma table_full_percent?), this way an almost-readonly table could use the full 100% of the page. So

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Dennis Cote
Doug Currie wrote: Friday, January 21, 2005, 1:33:35 PM, DRH wrote: Version 3.1.0 (alpha) of SQLite is now available on the website. Compiling with MinGW MSYS on WinXP... 1. I had to modify my lib/tclConfig.sh to have TCL_LIB_SPEC='-L/mingw/lib -ltcl84' instead of TCL_LIB_SPEC='' or else

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Dan Kennedy
--- Doug Currie [EMAIL PROTECTED] wrote: Friday, January 21, 2005, 1:33:35 PM, DRH wrote: Version 3.1.0 (alpha) of SQLite is now available on the website. Compiling with MinGW MSYS on WinXP... 1. I had to modify my lib/tclConfig.sh to have TCL_LIB_SPEC='-L/mingw/lib -ltcl84'

Re: [sqlite] Version 3.1.0

2005-01-21 Thread John Richard Moser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'd probably suggest something about how to set BLOB data from a void* and an int in 1 line of code, if I had any idea at all how blob data is set now. I found an example, but it was something like 400 lines long, overly complex (loading a blob into

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Greg Miller
Robert L Cochran wrote: I should have indicated in my earlier post that magazines which do side-by-side hardware testing are saying that the AMD Athlon 64 is indeed faster than the Pentium 4; for example look in the January issue of Maximum PC magazine. they have a followup test supplementing

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Roger Binns
I think all this discussion has missed the original question. Quite simply, is there any way in which the SQLite *source code* could be changed in order to get better performance on 64 bit machines. If there is then following questions should be answered: - Has it already been done (or should

Re: [sqlite] Version 3.1.0

2005-01-21 Thread Doug Currie
Friday, January 21, 2005, 5:41:00 PM, Dan wrote: autovacuum-ioerr2.4.0... Error: error copying test.db to backup.db: no such file or directory autovacuum-ioerr2-4.1.1... Error: error copying backup.db to test.db: no such file or directory autovacuum-ioerr2-4.1.2... Ok