So.. 71,000 records in an Access database..
Indexing for a search on 4 of 5 fields. BOOM! Verity indexing fails each and everytime on CFMX with 1Gig of RAM. *sigh* What's the solution? It works for 10,000 records (MAXROW = 10,000 in the CFQUERY tag). Help!help! -Gel ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists