Solved

ASP-ODBC??

Posted on 1998-08-07
5
359 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??
0
Comment
Question by:Coates
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 2

Expert Comment

by:Wiz_of_Oz
ID: 1858876
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?
0
 
LVL 2

Accepted Solution

by:
Jagar earned 30 total points
ID: 1858877
Yes you can use OLE DB drivers if there is a driver avialable for the type of database that you are connecting to.  This could be of an advantage because it would bypass and ODBC calls and go from ASP to OLE DB to the database.  Possibly speeding up you connections.
But the one thing that will speed up you connection the most is GOOD database design, limited the number of returned records in a recordset, using the simplest cursor that can be applied to the situation, ie not use a dynamic or snapshot cursor if all you need is a read only forward only recordset etc.
0
 

Author Comment

by:Coates
ID: 1858878
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.
0
 
LVL 28

Expert Comment

by:sybe
ID: 1858879
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.


0
 
LVL 28

Expert Comment

by:sybe
ID: 1858880
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.


0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question