So I am doing an AJAX call where I pull a bunch of information out of a database and build it into a huge table and then use AJAX to shove it inside a div. The issue I am having is that the AJAX call is taking over 8 seconds to complete! I checked my sql query and that is only taking 0.0074 seconds (fairly insignificant). I am pulling close to 7,000 records (and hope to increase this to a few million once I can get the timing way down).
Can someone explain how I can theoretically make this faster? I'm assuming this is the AJAX that is slowing it down, but Im new to the whole 'speed' thing. I'm used to developing smaller sites where speed wasn't a factor. Any help with any information would be greatly appreciated!