Dear Richard, > Patches to fix ticket #1346 are available at > http://www.sqlite.org/cvstrac/chngview?cn=2573
> Please try adding these patches and see if they do not > fix the problem in the multi-threaded application. Some results. (and bear in mind that I'm not sure that my particular core dump is addressed by this ticket, so 2 grains of salt should be shaken liberally in here... :-) 1st: I did manage to just drop this patch in (I didn't see any other dependencies) on top of the main 3.2.2 core and compile it (64-bit) on AIX. (If what I've said below is broken because there were dependencies, then by all means direct me to them and I'll gladly try again. I'm not using a CVS tree at this point.) That ran, but fell over at exactly the same select as before. So, no help there. 2nd: I tried dropping it into the DBD::SQLite 1.09 tree and compiling a new DBD driver (anyway). I was getting a very odd result on both 32 and 64 bit usages of the driver on AIX in that it couldn't load SQLite.so when it attempted to use DBD::SQLite. I know that's more of a Perl / DBD problem but I wanted you to be aware of it. That *didn't* happen on Linux - I dropped it into the DBD::SQLite tree, and managed to both use and run with it. It's slower... (!) I have a test app that was taking 1:45 (min:sec) to load something on Linux. Now it's taking consistently over 2:05. That might not look too significant, but this is less than 1/2 of one of the tables of this size in the database... So it seems to have added about 20s to that loading time. 3rd: Just as oddly, I tried dropping it into the 3.2.2 core on Linux and I had problems compiling, but that may be something to do with extra compile flags I have in there for other (quite unrelated) reasons. Anyhow, that's one set of results. Kind regards Derek.
