Re: [sqlite] SQLite Transaction Rate and speed...

John, looking at your example I have only some of the standard remarks that might help to speed up: 1. add an index on tbl_data(cell) since you query/update for cell = ?", each time. 2. Try to increase the cache for example by using: db.execDML("PRAGMA page_size = 4096;");

[sqlite] Import a CSV file

I use an excellent piece of software called AutoIT (http://www.autoitscript.com). AutoIt is a very flexible easy to use programming language which supports SQLite. I used it to write a csv import program for SQLite. Took me 10 minutes. If you would like to see the source as an example just say.

Re: [sqlite] which func could get the number of rows

I'm very happy that my question have triggerred the wiki-FAQ's question. but if the next version could solve(settle?) the question, many guys will be happy, :) and now, does it mean that we have to use link-list struct to write such kind of codes? Kees Nuyt wrote: > > On Fri, 6 Mar 2009

Re: [sqlite] import a CSV-File

Am Freitag, 6. März 2009 23:33:33 schrieb John Machin: > On 7/03/2009 6:16 AM, Rich Shepard wrote: > > On Fri, 6 Mar 2009, Hans-Martin wrote: > >> It seems that there is no way to get rid of the embedded CR/LF without > >> parse the complete output. > > > >Use sed. That's what it's for. > >

Re: [sqlite] Are there distillate posts in the sqlite3 board?

Yes, I'm looking for the digest articles. and appreciate you for you tell me that, :) Ribeiro, Glauber wrote: > > Are you looking perhaps for digest mode? Yes, there is a digest mode for > the SQLite email lists, it's one of the options you can set up. > > Or are you thinking of posts that

Re: [sqlite] which func could get the number of rows

On Sat, 7 Mar 2009 01:09:28 -0800 (PST), liubin liu <7101...@sina.com> wrote: >I'm very happy that my question have triggerred the wiki-FAQ's question. > >but if the next version could solve(settle?) the question, >many guys will be happy, :) In my opinion, there is no problem, so there is

[sqlite] is there any way to attach more than 10 databases ?

hi i have a problem , my program is returning me the message that sqlite is complaining, because it can't attach more than 10 databases at once. is that true ? and is there a way to attach at least 30 db at once ? thanx! bax -- View this message in context:

Re: [sqlite] is there any way to attach more than 10 databases ?

On Sat Mar 7 12:18:42 GMT 2009 baxy,,,hi.htnet.hr wrote: > i have a problem , my program is returning me the message > that sqlite is > complaining, because it can't attach more > than 10 databases at once. is that true ? > and is there a way to attach at least 30 db at once ? See "Limits In

Re: [sqlite] is there any way to attach more than 10 databases ?

On Sat, 7 Mar 2009 04:18:42 -0800 (PST), baxy77bax wrote: > > hi > > i have a problem , my program is returning me the > message that sqlite is complaining, because it > can't attach more than 10 databases at once. > is that true ? and is there a way to attach > at least 30 db

Re: [sqlite] SQLite Transaction Rate and speed...

If you need high concurrency then you probably shouldn't spend too much time looking at SQLite. That said, how often do you actually need to read information from this database? If you need to insert a lot but not necessarily read a lot you might consider simply appending new information

[sqlite] unrecognized token when trying to import (.read) a database

Hi. I'm trying to convert a sqlite3 database into sqlite2 database with: c...@emx:~$ sqlite3 banco.sqlite3 .dump > dump3 c...@emx:~$ echo '.read dump3' | sqlite banco.sqlite2 CREATE TABLE `abc` (`test` TEXT); SQL error: unrecognized token: "`" c...@emx:~$ I know that the problem is in `abc`,

[sqlite] Set read-only mode

Is there a way to set the current database handle as read-only? I'm connecting to an SQLite3 database (actually two including an attached database) using Perl with DBD::SQLite, which doesn't seem to implement the ReadOnly database handle attribute. Is there some kind of setting or pragma that

Re: [sqlite] Set read-only mode

On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer wrote: > Is there a way to set the current database handle as read-only?  I'm > connecting to an SQLite3 database (actually two including an attached > database) using Perl with DBD::SQLite, which doesn't seem to implement > the

Re: [sqlite] SQLite Transaction Rate and speed...

If your goal is to handle 1 million inserts/updates per second, and a hard transaction to disk takes 1/60th of a second, you need at least 1 insert/updates per transaction. Do your testing with a transaction size of 20,000 and see what kind of performance you get. I'd probably set it higher,

Re: [sqlite] import a CSV-File

On Fri, 06 Mar 2009, Rich Shepard might have said: > On Fri, 6 Mar 2009, Hans-Martin wrote: > > > It seems that there is no way to get rid of the embedded CR/LF without parse > > the complete output. > >Use sed. That's what it's for. > > Rich Or tr(1) if it's a single character. Mike

[sqlite] change the limitation of attached databases through perl

hi, i need help with attaching databases. in my last post i recived some valuable info on limitation of attached databases (Thanx !!). since i'm using perl (its DBI) all modifications like cache_size, max page number , journal size ... i've introduced through PRAGMA but for limitations on number

Re: [sqlite] Set read-only mode

On 8/03/2009 4:27 AM, P Kishor wrote: > On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer wrote: >> Is there a way to set the current database handle as read-only? I'm >> connecting to an SQLite3 database (actually two including an attached >> database) using Perl with

Re: [sqlite] change the limitation of attached databases through perl

On 8/03/2009 9:02 AM, baxy77bax wrote: > hi, > > i need help with attaching databases. in my last post i recived some > valuable info on limitation of attached databases (Thanx !!). since i'm > using perl (its DBI) all modifications like cache_size, max page number , > journal size ... i've

Re: [sqlite] sqlite3 datbase disk image malformed

Your rsync command might be ignoring any journal files that may be outstanding. John On Fri, Mar 6, 2009 at 10:33 AM, Derrell Lipman wrote: > On Thu, Mar 5, 2009 at 7:39 AM, Peter van Dijk > wrote: > > > On Thu, Mar 05, 2009 at 04:30:50AM -0800,

[sqlite] tool to browse a sqlite database

I'm loking for some gui tools for looking at and changing my sqlite database, the only ones I know of are the firefox extension and sqlitemanager. the firefox extension fails with: Error in opening file messages.sqlite - perhaps this is not an sqlite db file Exception Name: NS_ERROR_FAILURE

Re: [sqlite] tool to browse a sqlite database

Hi Eric, > I'm loking for some gui tools for looking at and changing my sqlite > database, See a comparison of several GUI SQLite tools here: http://www.tandb.com.au/sqlite/compare/?ml Tom BareFeet ___ sqlite-users mailing list