>However, we avoid accessing it directly whenever possible. About 4 gigs of data is unloaded into flat delimited files and ftped to our SQL Server box, where it is loaded into SQL Server on a nightly basis.
We do a similar process with our AS400. Although some of my CF pages do interact directly with the AS400, most of my data is pulled down to SQL every night. I do this because: 1. No one ever thought of creating indexes on the files in the AS400. Performance, on that machine, totally sucks. 2. No one uses the same datatype for related fields. For example, one ID number field may be numeric. In another file, it may be a char type. 3. The data is not very clean. We have birthdates with values like 'n092' and '00001204'. I bring down only data that is considered valid. 4. There is no referential integrity. We have thousands upon thousands of orphaned records in the AS400. 5. The AS400 may be unresponsive for long periods of time. The AS400 is completely out of my control, however the SQL servers are fully in my control. I can put more trust in SQL than the AS400. There are other reasons, but those are the big ones for now. M!ke ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219607 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
