Hannes Roth schrieb:
1. Why is the SQLite database much much bigger than the MySQL table and the raw csv file? I didn't use any index and vacuumed all the time ;)
SQLite does store everything as string, therefore the DB cannot be significantly small than the CVS-file. MySQL does store integers as binary values, this does require less space.
2. Why is SQLite twice as fast when using a small database (<3000 rows) and twice as slow when using a large database (>8000 rows)? Is this a harddrive issue?
I would assume that SQLite does have less overhead on each query. SQLite runs directly embedded into application process, MySQL is an Server - there is additional cost for TCP/IP communication.
Such things might easyly result in beeing faster on small jobs and slower on large ones - the communication overhead is mostly independent of the number of records in the table (as long as this does not enlagre the result-set)
Elmar
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
