I don't use MySQL, but I understand the locking issues have been fixed. I think you'll find things in it progress much faster than in the past now that Sun owns it.

>Actually, a better word might be different. Lacking implies it did not have when I mean it did not do it the way I understood. But the biggest issue for me was the transactions (of course that tells you I was not at first using inno) and then there were all the extensions.
>
>i.e. Data type
>long, medium, and tiny text and many more
>
>Joins along with group by work different. Of course that's true for Postgres and others.
>
>Lack of views, cursors, etc..
>
>And plenty of other little but very important items like max_rows, delay_key_write, etc...
>
>
>But to be honest MySQL was the first database I used to expand my VFP programs. I quickly found many things as not my cup of tea. I enjoyed MsSQL much more and others. About that time I got a small job using Oracle and had my eyes opened even more with the different syntax and features. So now I try to stay with Postgres. Postgres is very close to Oracle and still has much of the syntax of MsSQL without the locking issues.
>
>John