[sqlite] Re: Insert performance metrics

Hi, OK, I am impressed that you can insert 2000 records/second on indexed columns. I have an application that inserts CSV data into an SQLite database, and inserting 15 million records is taking about 2 hours with no indices (this is on a PowerMac Dual G5 2.0 GHz, 1.5 GB RAM), though

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

results don't work for me. Unfortunately I can't quite figure out what is different. Any ideas? - Steve On Oct 27, 2005, at 6:09am, Aaron Burghardt wrote: You can take a look at what Apple has done for OS X here: http://www.opensource.apple.com/darwinsource/10.4/SQLite-28/ Don't be mislead

Re: [sqlite] SQLite 3.2.5 and Mac OSX network folders

You can take a look at what Apple has done for OS X here: http://www.opensource.apple.com/darwinsource/10.4/SQLite-28/ Don't be mislead by the project name--it is SQLite 3. I haven't studied it closely, but it should allow you to build exactly what Apple shipped. The Makefile has

[sqlite] Need advise on performance optimization

Hi All, I'm trying to efficiently display a large table to users. I have a test database with 2.7M records that is 1.6 GB in size (though over half of that is 6 indexes). My best idea so far has been to display one "page" of the database at time, where a page is some arbitrary number

Re: [sqlite] Issue with Mac OS X and database file metadata (file size/disk free)

On Jul 19, 2005, at 7:50 PM, Aaron Burghardt wrote: On Jul 19, 2005, at 4:21 PM, Doug Currie wrote: [...] If I have exceeded the amount of free space, though, attempting to commit the transaction will fail. That is also as expected. SQLite will cache modified pages in RAM, and attempt

Re: [sqlite] Issue with Mac OS X and database file metadata (file size/disk free)

On Jul 19, 2005, at 4:21 PM, Doug Currie wrote: [...] If I have exceeded the amount of free space, though, attempting to commit the transaction will fail. That is also as expected. SQLite will cache modified pages in RAM, and attempt to write them to disk at commit time. OK, that's

[sqlite] Issue with Mac OS X and database file metadata (file size/disk free)

tly appreciated. Thanks, ----- Aaron Burghardt Booz Allen Hamilton 13200 Woodland Park Drive Suite 5035 Herndon, VA 20171 703-984-3112

Re: [sqlite] Possible enhancement to SQL logic

Try adding another index: CREATE INDEX a_f1_f2 ON a (f1, f2); Does that help? Aaron Burghardt On Jul 11, 2005, at 6:07 AM, Ben Clewett wrote: Dear SQLite, I have found a possible area where the SQL logic of SQLite is not as good as other DBMS. Like MySQL or PostgreSQL. It's a simple