Using the following test template to exercise basic SQL, I've found no obvious difference between CFMX 7 on Windows vs Red Hat Linux 3: http://www.talkingtree.com/downloads/index.cfm?item=macr%5Fsqlserver%5Ftest%2Ezip This test simply allows you to INSERT blocks of 100, 500, 1000 records, etc..., and then SELECT them.
I've tested with SQL Server 2000 using the default SQL Server JDBC driver that ships with ColdFusion MX 7. Inserting 100 records at a time usually required about 600-800 ms, and selecting 1500 rows usually required about 15 - 50 ms. Again, with this simple example there was no obvious difference and times were generally consistent. -Steven Erat On 7/16/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > I have a client who moved from CF 5 to CF 7 on Linux. Their DB is SQL 7 and > the queries are running much slower on CF 7 than they did on 5. Has anyone > seen anything like this in their sites and is there a known solution? > Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:14:4008 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
