I am using ZF 1.5.1, and Zend_Db_Select object with PDO_MSSQL adapter.

I have a javascript function that sends 2 queries to the MS SQL database with AJAX (jQuery getJSON). The first query is huge, while the second is a simple select. Given the "A" (asynchronous) of AJAX, I was expecting to the second query (the simplest one) to give the result before the huge query.

But what happens is that MS SQL receives the queries, and processes them synchronously: the first huge query is done, and only once it ends, the second query is done.

Is this normal? Shouldn't the database handle queries asynchronously?