ASP.NET Database/speed issue 1

[GhostWolf]

The front page of the site I'm creating contains a drop down list; the code-behind uses a SQL query to populate the list with almost 10,000 choices. This initial population takes almost forever to complete.

I've seen mention of services and, (although I know nothing about them yet), wonder if it might not be beneficial to set that list up as a service.

I'm not certain, though, because the pages that front page redirects the visitor to also take what I consider to be an inordinately long time to load - leading me to wonder how much of the speed problem is due to the limited-capacity server we're using.

Any advice would be greatly appreciated.

You should be able to get a look at the problem at

http://staging.jeffersoncountyclerk.org/wdiv

 

[GhostWolf]

That's a thought, but I'm using an XML data source. This project is a real learning experience for me; when I get the chance, I'll probably learn how to create/use web services, but right now I'm under a crunch to get the site working and went with the first/easiest way I could find.

 

[jmeckley]

you can query an xml source as well from a web service, the main point is autocomplete points to a uri. the resource on the other end of the uri does the actual work of querying the data source.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259