Last week I was working on a web crawler to crawl 250,000 URLs each night.  We had 5 client crawlers running and connecting to a master MSSQL 2013 database.  FusionGronker in ##coldfusion on freenode recommended that I try FusionReactor (a tool that allows you to monitor EVERYTHING that’s going on in your Java (ColdFusion) servers in real time. After many hours of debugging, I noticed every hour or so, a thread was getting stuck in a Native Method call.  There was no way to kill the thread, since it was…

Read More

I needed to prepopulate a database file for a Phonegap project that I was working on. My database was 10mb, so loading it from a SQL file via AJAX on the first launch was not an option. After many hours, I finally figured out how to do it. Enjoy! I hope this can be useful to some of you. Materials Required: PhoneGap https://github.com/chbrody/Cordova-SQLitePlugin/ Android Version, I used version downloaded on 8/7/2012. Versions differed a lot for me in updates. For example, the latest version automatically appends “.db” to your window.sqlitePlugin.openDatabase()…

Read More