This question is about the performance of queries in a database that i discussed here:<BR><BR>http://www.aspmessageboard.com/forum/databases.asp?M=524723&T=524723&F=21&P=1<BR><BR>Th e performance problem may be due to a design flaw discussed in the above post.....or could it just be Access????<BR><BR>When I run queries sometimes they take 5-6 seconds, sometimes they take over a minute. One table has a few thousand records and some of the related tables have a couple hundred. It doesn't seem right to me that these queries take so long.<BR><BR>I am just doing a prototype right now in Access and will do the actual implementation in SQL Server...and have to ask if these performance issues can be a problem in SQL Server too??<BR><BR>The table that right now has a couple thousand records will have over a million records in the actual DB....with a thousand or so being added every day.