To help anyone else who comes along: 1) the converter imports true as -1 so it works with vba/access front ends. Silly there's no option to set to 1 instead. (Also had to fix some old yes/no code issues.)
2) datepart sql is not supported. 3) wildcard brackets with LIKE sql are not supported. 4) have to insert dates as yyyy-mm-d format, which is clearer anyway! Everything else seems to be working so far. >You want to setup indexing - it'll speed things up. When I look in the administrator it shows an index on the id columns already if I'm reading it correctly. (in a box at the bottom right on the edit table dialog) I'm not sure what all else to index, though I understand to do WHERE clauses. For example in the item_category table there are id, category_id and product_id columns. It shows the id indexed. But I have queries that use where clauses on the latter two. So do I have to index all 3? When I checked before and after in the query browser, it didn't seem to make any difference. Does that mean I should de-index the two? In my products table should I index sale, new, display and a couple others, or does it quickly become overkill? Other indexing tips? Items beyond where clauses? Any way to check in the mysql tools what I should index? (nothing listed in slow queries in administrator) And how might I test the speed of various queries/indexings? By looking in the Query Browser times given at the bottom left of the screen? Finally, the manual says "MySQL supports many different storage engines (table types) and row formats." Is this something I need to look into? Thanks for any help. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2734 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
