• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

SQL Query data set size

Hi Experts,

This question relates to an SQL query I am using from this question.

http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_28342884.html

The query works fine until the rows in the database table get into the tens of thousands then it starts to return fewer and fewer valid rows as I add more rows. Are there limits to the amount of data various parts of an MS Access SQL query can handle?
0
DColin
Asked:
DColin
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
rows return by the query are based on the criteria of the query.
it doesn't matter if you added thousands of rows to the table, they will not be shown unless the records satisfy the criteria of the query.
0
 
DColinAuthor Commented:
capricorn1

But the query itself is having to manipulate and sort many thousands of rows even if the final result is a single row. Are there limits to the amount of rows an MS query can handle?
0
 
Rey Obrero (Capricorn1)Commented:
the recordsize limit return by a query is 1 gb

see this link

http://office.microsoft.com/en-us/access-help/access-specifications-HP005186808.aspx
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now