Hello!
On Wed, 19 Sep 2007, Biswadeep Chowdhury wrote:
This patch speeds up both the regular fetch, as well as the
fetchall_arrayref(). To me that seems better than ONLY speeding up
fetchall_arrayref.
If application requires fast response (as typical user
interface does), you may slow down the process. If you fetch from
complex query, you may get the first row immediately, and the next
row may require a few seconds to calculate. So, if you fetch by 1
row, you receive immediate response. If you fetch by 3 rows, you have to
wait for database to calculate 3 rows, before you get the response.
As I understand DBD interface, there is fetchrow_... interface
for 1-row fetch, and fetchall_arrayref() for multi-rows fetch.
Am I right?
Data caching is a good idea, but it should be tuned
per-statement. Though I don't know the way to do it, as prepare()
doesn't accept any additional attributes.
Bye. Alex.
