Hi
Let me get straight to the point. I'm using Delphi 7 and MS SQL server 2005
I've build up a bunch of SQL statements which creates, on MS SQL 2005, temp
tables and creates indexes on the temp tables it then performs selects on
tables to retrieve data to be inserted into the temp tables. Some of these
select statements contain scalar functions which calcs balance ect.
When I run the statements in query analyzer it takes 29 sec, however when I run
it in Delphi through an TADOComand it takes up 30 min !!!! I've tried using
TadoQuery object as well but has the same issue.
I don't need the TADOComand/ TadoQuery to return any information other than
that it was successful in creating and populating the temp tables on MS SQL
Server.
I tried setting activeControls to false for the TadoQuery when using it. I've
set eoExecuteNoRecords to True on the TadoCommand when using it, but with no
success.
Any help will be greatly appreciated
Regards
Frans Whyburd
--------------------------------------------------------
This e-mail, its contents and any file attachments transmitted with it may
contain confidential proprietary information and is the property of Fairheads
International Holdings or its subsidiaries ("Fairheads") unless the context
indicates otherwise. This e-mail is intended solely for the addressee. Access
to this e-mail by anyone else is unauthorised. If you have received this e-mail
in error you may not copy, distribute or use the contents, attachments or
information in any way. Please destroy it and contact the sender.
Unless clearly stated as being that of Fairheads International Holdings or its
subsidiaries ("Fairheads"), views, opinions, data or other information which is
unrelated to the official business of Fairheads, are those of the sender.
Fairheads accepts no liability in respect of the unauthorised use of its e-mail
facility or the sending of e-mail communications for other than strictly
business purposes. Should verification be required, kindly request the sender
to do so. No warranty is given that this e-mail is free of viruses, error,
interception or interference. No liability or responsibility is accepted if
information or data is, for whatever reason, corrupted, tampered with or does
not reach the intended recipient. Fairheads reserves the right to access,
block, monitor and intercept e-mail addressed to Users in Fairheads or take any
other action in accordance with its e-mail policy.
Licensed subsidiaries of Fairheads International Holdings are authorised
Financial Services Providers in terms of the Financial Advisory and
Intermediary Services Act, No 37 of 2002. Please be advised that the
information contained in this communication, including attachments does not
constitute advice in terms of the FAIS Act, No 37 of 2002.
Our corporate information is as follows:
Fairheads International Trust Company (SA) (Pty) Ltd, Registration No
1925/00272/07
Fairheads International Holdings (SA) Ltd, Registration No 1983/009226/06
Fairheads Umbrella Trust Company (Pty) Ltd, Registration No 1992/004041/07
For further information please visit our website at www.fairheads.com
__________________________________________________
Delphi-Talk mailing list -> [email protected]
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-talk
