We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

ASP-ODBC??

Coates
Coates asked
on
Medium Priority
449 Views
Last Modified: 2013-12-25
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??
Comment
Watch Question

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?
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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.

Commented:
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.


Commented:
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.


Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.