> How many indexes do you have setup on the table? I had a table with > about 6 million records that I inherited and it only had an index
It has all the pertinent fields included in indexes. I believe about 8-10 fields in the one main output table. All tables have all the indexes that are needed I believe. It just hit me this morning, I may be creating a bunch of data to query that'll never exist anyway. It's trying to count up 200,000 + records for one instructor. That'll never happen anyway! I think I need to load more real-world data into my tables and try it then. Maybe I'm asking something of it that nothing can handle, and we don't need that type of report anyway. make sense?? Thanks for your help! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
