I'm running dadabik on an xampp localhost. Small database files with approx 5,000 records are no problem, but I have 1 file that has approx. 520,000 records.
With a clean PC reboot and a new start of the xampp server the large dadabik file loads up quickly and the first couple of quick searches I do return a result in a couple of seconds. As soon as I try a "is not empty" or "is not null" filter I get spinning wheels and dadabik hangs. I have searched the forums and Google and tried theses suggestions: index all the fields I regularly search, take all the "Nulls" off the fields, but that doesn't fix the problem. Restarting the xammp server doesn't fix it either, so I have to re-boot the PC.
Looks like a memory problem but I can't figure out how to solve it. Any suggestions?
With a clean PC reboot and a new start of the xampp server the large dadabik file loads up quickly and the first couple of quick searches I do return a result in a couple of seconds. As soon as I try a "is not empty" or "is not null" filter I get spinning wheels and dadabik hangs. I have searched the forums and Google and tried theses suggestions: index all the fields I regularly search, take all the "Nulls" off the fields, but that doesn't fix the problem. Restarting the xammp server doesn't fix it either, so I have to re-boot the PC.
Looks like a memory problem but I can't figure out how to solve it. Any suggestions?