Replace root does not seems to work on huge sqlite db about pixivutil2 HOT 5 OPEN

After 1h30 I had some changes, it is just extremely slow.
Edit: no it did not work after all. :(

from pixivutil2.

fyi, it took 15879ms with this query:

UPDATE pixiv_master_image SET save_name = replace(save_name, 'I:\Pixiv', 'P:\Pixiv') WHERE save_name LIKE 'I:\Pixiv%'

And your code does exactly the same thing, so ... I dunno.

from pixivutil2.

maybe because of python sqlite lib? I cannot do anything if this true...

from pixivutil2.

@whinette
While testing update root, I found that the database is not committed until until the you exit the Manage Database menu. To be safe, try exiting the whole program normally after performing the update ( you will be prompted by menu again once it completes). This worked perfectly fine for me and I have >196,000 (43.1 MiB) entries.

If you are displaying your database in a GUI remember that you will have to refresh, because the records have changed in a transaction after the one initially used to display those results.

from pixivutil2.

I haven't seen any changes to my DB when using it.

the output of this text is instant, so it doesn't seem like anything really happened either.

from pixivutil2.