my sqlite code is slow :(

[Björnke von Gierke]

The SQLite database is local. A code that writes a similar amount of  
data into text files (where each file would be a record) is too fast  
to bother with any user feedback (at least on this machine).

As for not using an array, I haven't tried that yet, good idea. I'll  
try tomorrow, but i have multiline data and in addition, some fields  
might contain single quotes and other intervening stuff. So I'd need  
to introduce lots of escaping and data changing things to use a single  
string.

thanks for your thoughts, everybody
björnke

PS: and yes i too think that something must be wrong somewhere

On 23 Jun 2009, at 01:54, Sarah Reichelt wrote:

> 2009/6/23 Björnke von Gierke <bvg at mac.com>:
>> Well, i think i tried everything suggested, and then some...
>>
>> It seems that to create 1 mb of sqlite data, rev takes  
>> approximately half a
>> minute, no matter what one does to speed it up. too bad.
>>
>
> Without knowing much about it, I wonder is the problem creating the
> query from an array?
> I presume you are using the :1 :2 method of filling in the elements in
> a query. I have never used this but have always assembled my SQL
> queries as a complete string before executing. Could this be causing
> the slow-down?
> Is the SQLite database file on the local drive or on a networked drive
> i.e. is it possible that transfer speed is an issue?
>
> I haven't used SQLite much and even then, not for large amounts of
> data, but I have found it to be very fast, so I feel there has to be
> something wrong somewhere.
>
> Cheers,
> Sarah
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution