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??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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?