[DUG] MSSQL with D2007

[Kyley Harris]

100 fields.. That must be one mean table :)

On Wed, Jan 20, 2010 at 2:25 PM, John Bird <johnkbird at paradise.net.nz>wrote:

>  Think we solved this - its not memory - 1GB memory on the VM made no
> difference.
>
> It is the size of the records being got - over 100 fields and 4000 + bytes
> per record.
>
> If we ask for fewer fields its not surprisingly an awful lot faster.
>
> In others experience ADO is comparable in speed to other methods of loading
> data?
>
>
> John
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
> unsubscribe
>



-- 
Kyley Harris
Harris Software
+64-21-671-821
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100120/08d85b16/attachment.html