I have a query hitting our ERP system to show all product shipped to a state
- unfortunately this hits some of the biggest tables in the database and the
fastest I can get it down to is about 20-30 seconds. If I try adding
sorting or summing to it there is no way the customer will wait, so here i
Don't know the particulars but here are some thoughts:
1) I assume you are using a client-server db such as SQL Server
2) Doing it entirely within SQL is faster than SQL and CF combined
3) A single, more complex query is usually better than multiple,
simple queries (less data returned, less co
2 matches
Mail list logo
