Re: [sqlite] Big performance regressions since 3.4.0?

I think you can drop the following indexes as well CREATE INDEX FirstNameIndex ON PERSON(FirstName); CREATE INDEX LastNameIndex ON PERSON(LastName); CREATE INDEX CompanyIndex ON PERSON(Company); They are redundant in that you have compound indexes that start with each of the above. That should

Re: [sqlite] SQLite with NAS storage

Again, We have a lot of read/write operation. So, I guess the network latency is problem and think about lock management system. On Tue, Jan 6, 2009 at 11:23 AM, Edward J. Yoon wrote: > Hi, I'm newbie in here. > > I'm using SQLite, all data (very huge and 20 million

[sqlite] SQLite with NAS storage

Hi, I'm newbie in here. I'm using SQLite, all data (very huge and 20 million files) stored on NAS storage. Lately my system has been getting progressively slower. Network cost seems too large. To improve its performance, I'm think about local lock file instead of NAS as describe below. char

Re: [sqlite] Big performance regressions since 3.4.0?

Version 3.5.3 made a change to the way DISTINCT is processed. Probably that change is making your particular case much slower. The change can be seen at: http://www.sqlite.org/cvstrac/chngview?cn=4538 This change was in response to grumbling on the mailing list

Re: [sqlite] Big performance regressions since 3.4.0?

Dan, Thanks, I sent a separate email containing the source and data for my test app since it's too big (5M) to post to the group. But I'm also posting just the code for the test app here, in case anyone wants to take a look. On my target hardware, the results I got for the most egregious

Re: [sqlite] "meta command" via string via shell?

On Mon, 5 Jan 2009 10:02:14 -0800, "Webb Sprague" wrote in General Discussion of SQLite Database : > Hi list > > I would like to set my ".mode tabs" and then run a command like so > (yielding output separated by tabs instead of pipes): > > sqlite3

Re: [sqlite] Creating sqlite.dll and sqliteclient.dll for .net with sqlite version 3-3.6.7

Here is the link to the .Net data provider for sqlite... http://sqlite.phxsoftware.com/ On Mon, Jan 5, 2009 at 5:39 PM, Dao, Trien (STP) wrote: > I am new to sqlite development community. I need to create or obtain > sqlite.dll and sqliteclient.dll for sqlite version

Re: [sqlite] Creating sqlite.dll and sqliteclient.dll for .net with sqlite version 3-3.6.7

Trien, You might want to check this out: http://sqlite.phxsoftware.com/ I use it, and it works well for my needs. SB On Mon, Jan 5, 2009 at 5:39 PM, Dao, Trien (STP) wrote: > I am new to sqlite development community. I need to create or obtain > sqlite.dll and

[sqlite] Creating sqlite.dll and sqliteclient.dll for .net with sqlite version 3-3.6.7

I am new to sqlite development community. I need to create or obtain sqlite.dll and sqliteclient.dll for sqlite version 3-3.6.7. My questions are: 1) Where do I find the new versions of sqlite.dll and sqliteclient.dll 2) or where do I get the .NET version source code and where

Re: [sqlite] Exporting database to CSV file

Awesome. Thanks for the quick reply Deech :) J On Mon, Jan 5, 2009 at 2:34 PM, aditya siram wrote: > Open the sqlite database using: > > sqlite3 database.sqlite > >> .mode csv > >> .output yourfilename > >> your-sql -query > > -deech > > On Mon, Jan 5, 2009 at 4:21 PM,

Re: [sqlite] Exporting database to CSV file

Open the sqlite database using: > sqlite3 database.sqlite >> .mode csv >> .output yourfilename >> your-sql -query -deech On Mon, Jan 5, 2009 at 4:21 PM, Jonathon wrote: > Hello all, > > I am interested in exporting a particular table to a CSV file. I've > browsed >

Re: [sqlite] "meta command" via string via shell?

You didn't mention which OS you're in. This works in Unix: $ sqlite3 -help Usage: sqlite3 [OPTIONS] FILENAME [SQL] FILENAME is the name of an SQLite database. A new database is created if the file does not previously exist. OPTIONS include: -init filename read/process named file

[sqlite] Exporting database to CSV file

Hello all, I am interested in exporting a particular table to a CSV file. I've browsed google for a bit, but all I could find is third party programs. I was hoping this functionality was provided in sqlite and that it was super duper fast :) Thanks! J

Re: [sqlite] problem with ".dump" -- not generating insert statements on biggish table (12K by 2.8K)

Hi again, Just hoping that someone might have an answer to my question about ".dump". I just tried it again on a different database with a similar result... -W On Sun, Jan 4, 2009 at 2:39 PM, Webb Sprague wrote: > Hi All, > > When I run ".dump" on a small table I

Re: [sqlite] Quick question:

S B a écrit : Pocket PC use a arm/xscale processor, not a x86.The os is also differnet (windowsCE vs win32). A recompile is needed with the right tool (evc3, evc4 of visual studio 2005/2007). Best wishes Noël > Jason, > > Chances are you will have to compile it for CE. I imagine it uses a >

Re: [sqlite] Quick question:

Jason, Chances are you will have to compile it for CE. I imagine it uses a different compiler/SDK than standard XP. Use the amalgamated version of the source - it's very easy. SB On Mon, Jan 5, 2009 at 1:28 PM, jason young wrote: > Quick question: > Can anyone tell

Re: [sqlite] "meta command" via string via shell?

I've been using SQLite for about 5 years now, and the "put the commands in a file" is the best answer I'm aware of. -T On Mon, Jan 5, 2009 at 1:44 PM, Webb Sprague wrote: >> If I understand correctly, all you need to do is write the desired >> commands out to a

Re: [sqlite] "meta command" via string via shell?

> If I understand correctly, all you need to do is write the desired > commands out to a text file, then either direct stdin to the text file, > or use the '.read" command. Yes, I could write the commands out to a file (ick!), but I don't really want to add four lines and a whole lot of I/O. I

[sqlite] Quick question:

Quick question: Can anyone tell me what is involved with getting a WinCE 5.0 executable that I can do some testing and development with. I tried to take the Windows executable on the download page and run it on CE but it failed claiming that it could not SQLite3 (or one of its components). FYI,

Re: [sqlite] "meta command" via string via shell?

Regarding: "...but this doesn't work because the .mode tabs isn't separated from the regular SQL. Could someone point out how to accomplish this?" If I understand correctly, all you need to do is write the desired commands out to a text file, then either direct stdin to the text file, or

[sqlite] "meta command" via string via shell?

Hi list I would like to set my ".mode tabs" and then run a command like so (yielding output separated by tabs instead of pipes): sqlite3 NLSY.db '.mode tabs; select * from DS0001 limit 1;' but this doesn't work because the .mode tabs isn't separated from the regular SQL. Could someone point

Re: [sqlite] sqlite and threads

Ken, Thanks for the suggestion. I'm currently doing what you suggested in that each thread has its own connection. I was wondering if I would see any kind of performance gain by using one connection instead of N. My guess is I would see a bit of a boost, but it seems like a rather large effort

Re: [sqlite] sqlite and threads

SB, You could compile sqlite without the thread safety. Then roll your own locking mechanism. Only one thread at a time can be accessing the database connection/Statements. And it would be a good idea to have whichever thread complete its transaction/work prior to release control to another

[sqlite] sqlite and threads

Hello, From: http://www.sqlite.org/faq.html#q6 "The restriction on moving database connections across threads was relaxed somewhat in version 3.3.1 . With that and subsequent versions, it is safe to move a connection handle across threads as long as

Re: [sqlite] Inserting an image file?

aditya siram writes: > > Hi all, > How do I insert an image file into sqlite table? Can I just use a > path-specifier? For instance, > create table ("name" varchar, "data" blob); > insert into table ("someBlob", "./blob.jpg"); > > thanks, > deech But obviously holding the