Hello jjroman We�ve got the same problems when we migrate from CF5 to CFMX.
The frist step is to install the latest patch pack from Macromedia. The JDBC driver is as better as the orginal. The second step is: Are you use Oracle 8i for your applikation? When you use Oracle 8i please transform the CLOB Datafields to LONG to increase the performance. The tables that must be converted are :OBJECTS,EXTENDEDDATA In our case we are after the transforming we save 2/3 time in each request (75% faster!). Here is a small hint to create the new tables: look into allaire/spectra/customtags/datamigration/_oraclegeneratetables(change the CLOB SQL into : objectdata LONG NULL ,). Two ways to convert the tables: SQL command or COAPI copy from source database to target database by first drop table and recreate it by the code _oraclegeneratetables . Spectra manages the huge objects inside by splitting into chunks. All your applications should be running well . kind regards SYSOPT ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how to get a fax number that sends and receives faxes using your current email address http://www.houseoffusion.com/banners/view.cfm?bannerid=64 Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5663 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.17 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
