|
|
Posted by Brad on 06/30/05 23:46
I have an sql query that has specific criteria (like state='PA' or
state = 'NJ'...) and would like to be able to have the user specify
the criteria dynamically either through the web or from MSAccess or
another tool.
The query also does a GROUP BY the state and other variables that are
part of the criteria.
I know how to get MSAccess and asp pages to do the sorting and
selecting against an SQL tbl or view, but when access queries the same
info as the original sql view, the process takes much longer than when
the sql view does all of the sorting, selecting and grouping..
The table we are currently using is 5 million records and will be
growing to 250 million records shortly, so speed is of the essence.
The sql views and MSAccess are both running from the same server so
there is no issue at this point of a network impacting the MSAccess
query.
Any suggestions...
Navigation:
[Reply to this message]
|