Jason Smith wrote: >I have a client that has access backend for his cf application, when trying >to run a query for a report that checks for item status the page always >times out never will load. The query works on other reports with no >problem. There are about 1500 products in the field and the status id is >numerical from 1-10. > >Now myself personally I would never use an access database for this type of >work I would prefer to use mysql but I don't have that choice. So if anyone >is familiar with cf/access or know of any issues that have to do with >access indexing not working correctly under a cf app please let know. > > 1500 records is really a drop in the ocean for what, the much maligned, Access can handle. Its not ideal for a web app, but it'll handle a hell of a lot more traffic than is generally made out with careful querying and the judicious use of the various types of caching available in CF.
The problem sound like it is down to the query and the indexes on the tables. Can you tell us the query and the table structure, specifically the column type and indexes for the columns that are joined? Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
