|
| |
|
|
cswolf
Posts: 50
Joined: 11/9/2005
Status: offline
 |
slow search results from Access DB - 5/5/2006 9:40:49
Hi,
I'll try to be as coherent as possible with this request for help, so here it goes...
Server: Windows 2003 running IIS 6
Using language: ASP
I am having an issue of slowness on my intranet server when doing searches through two completely different Access databases. The problem started when we added the 2nd DB search, and we can't figure out why. Here was the setup:
Originally there was a phone directory search which worked great - it was blazing fast. We added another Access DB to the website and wrote a page in ASP to search the 2nd DB. Ever since we have added this search, BOTH searches now are painfully slow - almost to the point where it is unuseable. The phone directory DB/search page was never touched during this whole process, so we are confused as to why BOTH are running slow. The two DB's/search pages are completely seperate from each other. They are not connected in any way.
Both searches use a DSN-less connection.
Can anyone provide any tips on where to start looking to fix this problem? If you need more information from me, I'll provide what I can. Thanks!
|
|
|
|
cswolf
Posts: 50
Joined: 11/9/2005
Status: offline
|
RE: slow search results from Access DB - 5/8/2006 13:40:25
quote:
ORIGINAL: Spooky
Where are the connections accessed from?
I'm not quite sure what you are asking here. The connections to the DB are made from within the ASP code of their respective search pages.
quote:
What type of DSNless conenction string are you using?
I am using something that looks like this:
Dim conn
set conn = server.createobject ("adodb.connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBq=" & server.MapPath("/path_to_my.mdb")
For what it's worth - the original search page for the phone directory DB was written by a 3rd party, and after examining their code we couldn't make heads or tails out of how they were connecting to the database. I replaced their code with the line I pasted above so now both search pages connect to their respective DB's the same way and now suddenly they are functioning ok. Does that make any sense?
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 