Re: [sqlite] Plugin help requested

2006-03-05 Thread K. Haley
cstrader wrote: > I'm trying create a .dll. The .dll compiles and looks fine and the code runs > fine in console mode, but the host cannot read the .dll when the sqlite3_open > line below is uncommented. Any ideas why would be appreciated. thanks! > > #include > #include > > #define

[sqlite] Coverity Open Source Defect Scan of SQLite

2006-03-05 Thread Ben Chelf
Hello SQLite Developers, I'm the CTO of Coverity, Inc., a company that does static source code analysis to look for defects in code. You may have heard of us or of our technology from its days at Stanford (the "Stanford Checker"). The reason I'm writing is because we have set up a framework

[sqlite] Plugin help requested

2006-03-05 Thread cstrader
I'm trying create a .dll. The .dll compiles and looks fine and the code runs fine in console mode, but the host cannot read the .dll when the sqlite3_open line below is uncommented. Any ideas why would be appreciated. thanks! #include #include #define _SQLITE3_H_ extern "C"

Re: [sqlite] .import Optimization

2006-03-05 Thread Joe Wilson
Kevin, I'm sure the SQLite mailing list would very much like to hear how long it takes to insert 400 million rows with (and without) an index using a PRAGMA cache_size=3000 on a 48G RAM machine. And how big the final database turns out to be. You might also want to play with a larger

Re: [sqlite] Re: help

2006-03-05 Thread Jay Sprenkle
On 3/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Muthuraman Swaminathan <[EMAIL PROTECTED]> wrote: > > Dear Sir, > > I sent the following message but it was returned.Can you please approve > > this message.Thank you sir. > > > > > > Hi all, > > How to store a JPEG image into SQLITE

Re: [sqlite] .import Optimization

2006-03-05 Thread drh
"Kevin Bartz" <[EMAIL PROTECTED]> wrote: > Hi SQLite, > > > > Thanks for building such a wonderful product. I've used BerkeleyDBs in > the past and have been pleased to have SQLite's SQL interface. That > said, I have some questions about optimizing .import. > > > > I'd like to load a

[sqlite] .import Optimization

2006-03-05 Thread Kevin Bartz
Hi SQLite, Thanks for building such a wonderful product. I've used BerkeleyDBs in the past and have been pleased to have SQLite's SQL interface. That said, I have some questions about optimizing .import. I'd like to load a tab-delimited file that's about 40G and has 400M rows, and I'd like

[sqlite] Re: help

2006-03-05 Thread drh
Muthuraman Swaminathan <[EMAIL PROTECTED]> wrote: > Dear Sir, > I sent the following message but it was returned.Can you please approve > this message.Thank you sir. > > > Hi all, > How to store a JPEG image into SQLITE using java.Can anyone please give a > sample code.How to