Hi,
1. Best Version of MYSQL for very large Tables
Can I get some tips for which MySQL version to use
For maintaining a large DB with 100-200 million row master table
With a lot of inserts.
e.g. Is MAXDB version specifically setup for this ?
2. Fastest Loading of Data in Master Table
Can I load data faster using MAXDB then with the standard MYSQL ?
3. Searching large tables based on Criteria ?
a. using index
b. use Set columntype
c. using Fulltext Search
I will need to make scans of the table to extract certain customer
accounts based on criteria.
I thinking of using the SET column feature which enables 64 different
keywords to extract rows based on search criteria. The other alternative
is to try and use the FullText Search feature.
Can anyone recommend either way based on there experience ?
Thanks, Paul
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
