Analysis of 2 asp pages / possible redo(repost)

I have two pages on our companies website that search our database for products by manufacturer or by product types (aka CD ROM drives, etc...). These pages list everything instead of the drop down menus we also offer. The problem is that these two pages are taking a long time to grab the data and show, where as the rest of the site is not taking any time at all. I need someone to analyze the files, and see if there is a better way to program the pages (and do the programming), or let me know if the problem does not lie within the coding. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform These are 2 asp pages that connect to an oracle database for information. there is some sql coding.