On 2016/04/20 3:31 PM, Cecil Westerhof wrote: > 2016-04-20 12:35 GMT+02:00 R Smith <rsmith at rsweb.co.za>: > >> >> On 2016/04/20 10:50 AM, Cecil Westerhof wrote: >> >> The Devs do read the list, and often post, and they will be very >> interested in what you have discovered if it is not a system anomaly on >> your side. (Perhaps even if it is). Can you post the DB file somewhere and >> the steps to reproduce? >> > ?It is 512 MB, thus that is a bit difficult. But would a Java program to > generate it suffice? > > The steps to reproduce is to run the script I posted. That supposes you run > Linux, but it should be easy to adapt.
The problem is, our running the same script (as have been posted) produces a DB that takes a mere few seconds to drop the table, as expected. Something in your setup is producing DB files that, with your setup, takes ages to drop and perhaps better to delete and then drop, but we cannot reproduce those results, so if you can post the DB somewhere, on some server or file upload site, the devs could examine it and conclude whether your system produces a file which somehow takes ages to drop with possible difference in time for drop and delete or just drop, - OR - that your file takes little time to drop here with delete or not. Once the result is known the devs will know that either: - The produced DB file is not the problem, nor is the SQLite code, your setup is just weird (perhaps then further examine/test with your compile options), OR - The produced DB does have a problem with dropping vs. delete-then-drop, so how can it happen?... and thus time to look at what can be done to make it better. But without the file, all the above is a guess. Did you gzip it? Is it still 512MB? Most file upload sites can handle half a gig easily.
