July 29, 2003 at 5:48 am
i have sql server 2000 as server and vb6 as client. whenever i show a form on client , it fetch the data lately. i check the taskmanger the CPU is 99 percent idel all the time, i have 9 adodc control on the form. and data is also not much in tables.
what will be cause of taking time of form display. >
August 1, 2003 at 8:00 am
This was removed by the editor as SPAM
August 1, 2003 at 9:35 am
Hard to tell. Have you run the same queries in Query Analyzer?
Steve Jones
August 3, 2003 at 11:40 pm
Hi msaleem,
quote:
i have sql server 2000 as server and vb6 as client. whenever i show a form on client , it fetch the data lately. i check the taskmanger the CPU is 99 percent idel all the time, i have 9 adodc control on the form. and data is also not much in tables.what will be cause of taking time of form display. >
it might be helpful to post some example code. So as your query strings....
Personally I don't use the ADO Data Control too much, because it imposes a small overhead on memory.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply