100 fields.. That must be one mean table :)<br><br><div class="gmail_quote">On Wed, Jan 20, 2010 at 2:25 PM, John Bird <span dir="ltr"><<a href="mailto:johnkbird@paradise.net.nz">johnkbird@paradise.net.nz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#ffffff">
<div><font color="#000000" size="2" face="Arial">Think we solved this - its not memory
- 1GB memory on the VM made no difference.</font></div>
<div><font color="#000000" size="2" face="Arial"></font> </div>
<div><font color="#000000" size="2" face="Arial">It is the size of the records being
got - over 100 fields and 4000 + bytes per record.</font></div>
<div><font color="#000000" size="2" face="Arial"></font> </div>
<div><font color="#000000" size="2" face="Arial">If we ask for fewer fields its not
surprisingly an awful lot faster.</font></div>
<div><font color="#000000" size="2" face="Arial"></font> </div>
<div><font color="#000000" size="2" face="Arial">In others experience ADO is
comparable in speed to other methods of loading data?</font></div>
<div><font color="#000000" size="2" face="Arial"></font> </div>
<div><font color="#000000" size="2" face="Arial"></font> </div>
<div>John</div>
<div> </div></div>
<br>_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br></blockquote></div><br><br clear="all"><br>-- <br>Kyley Harris<br>Harris Software<br>
+64-21-671-821<br>