Link to home
Start Free TrialLog in
Avatar of Coates
Coates

asked on

ASP-ODBC??

I am using ASP to access a database via ODBC. I find that this is very slow however. Is there another method of accessing a database using asp without using ODBC??
Avatar of Wiz_of_Oz
Wiz_of_Oz

it's 2 yers that i'm working on asp data management via odbc and i've found a lot of things that are not working very well but i never found connection slow....
what kind of odbc r u using?
how many records are there into your tables?
casn u give me more info to help you to speed up connection?
ASKER CERTIFIED SOLUTION
Avatar of Jagar
Jagar

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Coates

ASKER

At the monent there are 40,000 records in the database. This is an SQL server database. When i use ODBC to connect to the db and retieve results it is very slow. But when i use the SQL server query tool The results are returned very fast.
Avatar of sybe
It might depend on how the results are shown in a browser. If the result list is long and displayed in a table, the browser not display anything untill all results are "in" and the table layout can be calculated.


It might depend on how the results are shown in a browser. If the result list is long and displayed in a table, the browser will not display anything untill all results are "in" and the table layout can be calculated.