slow search results from Access DB (Full Version)

All Forums >> [Web Development] >> Server Issues



Message

cswolf -> 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!



Spooky -> RE: slow search results from Access DB (5/5/2006 21:53:35)

Where are the connections accessed from? What type of DSNless conenction string are you using?



cswolf -> 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?



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875