Hi All,
I have a some performance problem on INSERT to temporary table.
My temporary table is very simple:
TABLE
{
ID TEXT (Primary key) // The format is GUID
}
On user request, I receive list of ids from outside component and would like
to store them in a temporary table for later use.
Every time that I receive new ids I delete the old temporary table, create a
new one and store the data again.
Sometimes insert of 7000 ids takes more than 8 sec.
If I receive the same ids again and do the whole thing again (delete the
temp table, create new one and insert) it takes only few milliseconds.
Note: All of the above operations is done within a transaction.
What can I do in order to improve performance? Will it be better to delete
the content of the table instead of delete the table and recreate it?
Thanks,
Ofir.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
