Which Format?

[insania]

I am thinking of changing our VFP Databases to MySQL due to size issues?

I need to use transactions, what database format within MySQL should I choose?

May be a daft question, but: Why do you guys like MySQL? Should I commit to it?

Out of interest, how many fields can I have in a table in MySQL?

Questions, questions!!

 

[sleipnir214]

If you need transactions, then you should probably go with InnoDB tables. MyISAM tables do not support transactions.

I don't know the maximum number of columns a table can support, this page, titled "How Big MySQL Tables Can Be", has an eighteen-month-old user-supplied comment which puts the number at 3398. However, I have never, in any relational database, needed anywhere near that many, as I've always found that data should and could be stored in separate related or relatable tables.


Want the best answers? Ask the best questions!

TANSTAAFL!!