<?xml version="1.0" encoding="windows-1252"?>
<node id="455314" title="Re^2: DBI speed up needed on MySQL" created="2005-05-09 16:35:24" updated="2005-06-13 21:37:24">
<type id="11">
note</type>
<author id="223311">
jacques</author>
<data>
<field name="doctext">
That's what I ended up doing. Just sending stuff a little at a time with the limit clause, but this is not ideal. Hopefully, under normal circumstances, my script would not handle tens of thousands of rows at once. For important testing purposes, we decided to send over &lt;i&gt;all&lt;/i&gt; the rows (and that's when we see the huge slowdown). So far, the bottleneck appears to be what [thor] suggested: mysql fetches all of the data before returning the first row. The more I increase the limit, the longer it takes to process the first row. ...</field>
<field name="root_node">
454953</field>
<field name="parent_node">
455294</field>
</data>
</node>
