> Some of my frustrations with MySQL are: > - Only 1 query per <cfquery>
MySQL can handle multiple queries, it's just disabled by default. Cameron Childress has a post about this. MySQL: How to Combine Multiple SQL Statements in One CFQUERY http://www.sumoc.com/blog/index.cfm?mode=entry&entry=7F6F7314-5004-2066-B7A8BDFB26843712 > - Unable to handle complex join queries e.g. I ran a complex query in > a trail version of SQL Server 2000 and it returned in 3 seconds, it > took 33 mins in MySQL (this may be becuase we are using a non > enterprise version - are there different versions???) I've written extremly complex joins in MySQL that run very fast. Have you checked the indexes? Are the tables using MyISAM or InnoDB format? > - The server grinds to a holt with my complex queries which in turn > kills the website. The same thing happens when I try to export a > backup of the entire DB. Are you using the command-line backup or the MySQL Admin UI? -- Adrian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
