On Wed, Apr 4, 2012 at 1:19 PM, Jeffrey Van Voorst <[email protected]> wrote: > Sad part is mysql doesn't have an async C API. Probably a good reason to > use postgres. Although one could fake it using pthreads like libeio does > for files.
ahh, no that's not a problem, unless you're doing seeeriously CPU-intensive mysql (or even postgresql) queries, or queries returning megabytes of data. if you're sensible those (typically) two outstanding AJAX queries that you're allowed, they're enough to keep the responsiveness. a typical approach would be to add in paging of results (using LIMIT etc.) which, to gain responsiveness in the UI you're going to have to do _anyway_. last thing you want is to make the server do massive amounts of work to create 100,000 records, then make the browser do massive amounts of work storing all 100,000 results in memory, then only display the top 10! l.
