Re: [sqlite] Problem writing to database using PHP under OS X

At 15:39 14/07/2008, John LeSueur wrote: >On Mon, Jul 14, 2008 at 4:28 AM, Tim Streater <[EMAIL PROTECTED]> >wrote: > > > I have a small script which shows this problem: if I run it from the > > command line I can read from and write to the database. If I run it in a > > browser it fails at the

[sqlite] Windows CE performance

Hi, I use Windows CE. I was using a version of SQLite 3.2.2 I got from sourceforge.net I decided to download the latest 3.5.9, I compiled and everything seems to work OK on Windows CE. But I noticed a very big performance decrease. In my application I had a process that took about 30 seconds.

Re: [sqlite] Windows CE performance

Hello Filipe Have you already checked your PRAGMA settings four your embedded version? (see http://www.sqlite.org/pragma.html) On which operation do you have you performance decrease? Is it INSERT performance? Daniel ___ sqlite-users mailing list

Re: [sqlite] Windows CE performance

Hi, What PRAGMA settings should I check? The locking_mode? Yes, the problem is with INSERT. I am running about 3500 Inserts inside a transaction (BEGGIN TRANSACTION -> COMMIT TRANSACTION) Cumprimentos / Best Regards Filipe Madureira

[sqlite] General help, a bit OT

A bit off topic, but perhaps someone could direct me. I'm in vb.net I have to read thousands of tables and operate on each one in sequence. I need to do this fast. I want to read the data from 6 stored columns and many rows from each table. Once the table is read, I need to create derived

Re: [sqlite] General help, a bit OT

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of cstrader > Sent: Tuesday, July 15, 2008 2:03 PM > To: General Discussion of SQLite Database > Subject: [sqlite] General help, a bit OT > > A bit off topic, but perhaps someone could direct me. > >

Re: [sqlite] General help, a bit OT

Oh, sorry, the example was just an example. The calculations I need to make on on ColC cannot be done within SQLite. - Original Message - From: "Szomraky, Stefan" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" Sent: Tuesday, July 15, 2008

Re: [sqlite] General help, a bit OT

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of cstrader > Sent: Tuesday, July 15, 2008 2:28 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] General help, a bit OT > > Oh, sorry, the example was just an example. The

Re: [sqlite] Datetime issue with the time part

Eric Minbiole wrote: > From what you describe, it seems that the compiler is performing > single-precision, rather than double-precision, math. After a quick > Google search, I found a few posts indicating that Direct3D silently > switches the FPU from double to single precision math,

Re: [sqlite] IOERR_DIR_FSYNC on main db

Dan, I'll test this with a quick bit of C code and get back to you with the truss output. Good catch Roger! ( and thanks) Thanks, Ken Dan <[EMAIL PROTECTED]> wrote: On Jul 15, 2008, at 9:00 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Ken wrote: > >>

Re: [sqlite] patch to allow integer rtree keys

wrote: On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman wrote: > I've just started using the rtree extension, and have found that > the 32-bit > float for the range keys is not appropriate for me. Please find > attached a > patch for rtree.c (based on v1.5)

Re: [sqlite] IOERR_DIR_FSYNC on main db

On AIX, you might want to open the files using O_DSYNC flag: (see) http://publibn.boulder.ibm.com/doc_link/en_US/a_doc_lib/libs/basetrf1/open.htm#HDRA1509805 Test results: Opening for rdonly kwrite(1, 0xF0373B18, 19) = 19 open("/home/ixion/T", O_RDONLY|O_LARGEFILE) = 3

Re: [sqlite] Windows CE performance

Hello As usual, there is no general rule. You have to define the best settings for your embedded environement yourself. Start here: "[sqlite] Performance tuning using PRAGMA, other methods" http://www.mail-archive.com/sqlite-users@sqlite.org/msg29343.html Try different settings to get the

Re: [sqlite] Windows CE performance

Hi, Thanks for your help. Just one question, you asked me in your previous e-mail if it where INSERT operations. Do you think it may be related to this? Do you know of some issue about INSERTs that can slow performance in the recent versions? Because the other operations seem better. Only the

Re: [sqlite] IOERR_DIR_FSYNC on main db

Sorry but after a second read, probably don't want the O_DSYNC except for maybe an initial opening of any persistent file ( open(o_dsync), close, re-open ?). Ken <[EMAIL PROTECTED]> wrote: On AIX, you might want to open the files using O_DSYNC flag: (see)

Re: [sqlite] IOERR_DIR_FSYNC on main db

Just as a side note this was on an AIX 5.3 system using JFS. I wonder what would happen if some other filesystem was in in use, such as VFS,UFS etc? Ken Ken <[EMAIL PROTECTED]> wrote: Sorry but after a second read, probably don't want the O_DSYNC except for maybe an initial opening of any

Re: [sqlite] IOERR_DIR_FSYNC on main db

This was on an AIX 5.3 system using the JFS filesystem. I wonder what would happen on a JFS2, VFS or UFS filesystems? Ken Ken <[EMAIL PROTECTED]> wrote: Sorry but after a second read, probably don't want the O_DSYNC except for maybe an initial opening of any persistent file ( open(o_dsync),

[sqlite] requested patch to rtree.c v1.6

I happily saw the changes to rtree.c v1.6 and have the following requested changes: 1) On a 64-bit machine, compilation generates two warnings: sqlite3.c: In function ‘rtreeCreate’: sqlite3.c:90889: warning: cast from pointer to integer of different size sqlite3.c: In function ‘rtreeConnect’:

[sqlite] Recent minor fts3 changes.

Since fts3 development is sort of sporadic, I figure it's worth a heads-up about a minor feature I've recently checked in. -scott *** http://www.sqlite.org/cvstrac/chngview?cn=5417 optimize() function. This takes all segments in the fts3 index and merges them into a single segment. As a side

Re: [sqlite] General help, a bit OT

Oh, well that's interesting. I didn't know I could apply a function to create a new column as I read the data. I have to figure out how to make that work in vb.net. More generally, can I create a new blank column in my datatable as I read from an existing set of columns? Or must I do a copy

Re: [sqlite] General help, a bit OT

is it true that C is always (or even generally) faster than .net? - Original Message - From: "Szomraky, Stefan" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" Sent: Tuesday, July 15, 2008 8:40 AM Subject: Re: [sqlite] General help, a bit OT

Re: [sqlite] General help, a bit OT

Without causing a rehash of that long-debated topic, I'll say this: As it relates to SQLite, generally you will get better performance out of an optimized C application talking to SQLite than you will out of .NET talking to SQLite. The difference can be insignificant to a user application

[sqlite] [Fwd: FTS statistics and stemming]

Hello Scott et al, I posted this to the list a while back but never got a response from anyone. It would be great if you could take 5 mins to read and respond to this. I have been reading through the fts3 code, but there is a lot of it and I'm not sure how it works from a big picture let along