snufse, Have you tried timing the query by itself directly against the database? How long does it take? Gary
Remember to mark your thread as resolved. Remember to rate posts that help. Hitchhiker's Guide to Getting Help at VB Forums. ASP.NET Tutorials (updated Feb 1st 2009) ASP.NET FAQs (updated July 17th 2011) Free Stuff: WebsiteSpark|DreamSpark|BizSpark|eBooks Learning Resources: MSDN|LearnVisualStudio|TrainingSpot|ScottGu's Blog|ASP.Net Starter Kits|Regex|RegExLib Useful Tools: XPath Builder|UltraMon|RegExBuddy|CopySourceAsHtml|TracExplorer|SQLyog|Chart Controls for .Net|SharePoint Designer|CodeRush Express Coding Links: XPath|ConnectionStrings|VB and MySQL|MySQL Connector.Net|My.Settings ADO.Net: MSDN Reference|Introduction|Using Access|Always use Parameters|Save and Retrieve Data - jm|An Explanation - jm Code Bank Submissions: Code Snippets|Profile Provider|Serialization: C# VB|Restricted Menu|Compressed HttpWebRequest|Enumerate and Add Internet Explorer Favourites: VB C#|C# Tabbed Web Browser|Enhanced Tabbed Web Browser: VB C# My Blog - View my MCP Certifications
Forum Rules
Reply With Quote