2016-04-20 16:07 GMT+02:00 R Smith <rsmith at rsweb.co.za>: > > > 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.
?It is still 411 MB. When I am home I will try it on another system also to look if there the timing is differently. Is there an upload site you recommend? By the way: it could be that Java is the culprit. ? -- Cecil Westerhof
