Peng,
Dropping very large tables is time consuming. Dropping a 59GB table
takes quite a long time for us even on fast hardware. Dropping smaller
tables is faster though.
Not sure what size tables you have but something to think about. We
experimented with new tables and changing old tables and for us,
dropping the table and creating a new one was the fastest method but
still took 40-60 mins from memory.
Rob
On 4 Sep 2019, at 11:18, Peng Yu wrote:
For now, I just delete the db file if it exists already. So that I
don’t
need to call DROP TABLE IF EXISTS mytab. I guess directly deleting the
db
file can be faster than the latter. Is it so?
On Tue, Sep 3, 2019 at 3:06 PM Simon Slavin <slav...@bigfraud.org>
wrote:
On 3 Sep 2019, at 8:57pm, Peng Yu <pengyu...@gmail.com> wrote:
If I try to create a table that already exists, sqlite will give me
an
error. Is there way to issue one command to create a table, but if
there is
already a table with the same name, drop it then create the new
table?
Thanks.
Assuming that the new table has a different structure to the old one,
do
it in two commands:
DROP TABLE IF EXISTS MyTable;
CREATE TABLE MyTable ...;
Neither of those commands will generate an error.
If you are sure that the new table has the same structure as the old
one,
you can do
CREATE TABLE IF NOT EXISTS MyTable ...;
DELETE FROM MyTable;
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Regards,
Peng
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users