Solved

ASP-ODBC??

Posted on 1998-08-07
5
290 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
5 Comments
 
LVL 2

Expert Comment

by:Wiz_of_Oz
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will learn how to count occurrences of each item in an array.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now