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 <b...@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
