Hello Paul, > 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.
If there is concurrency (i.e. multiple users) in the insert, either of course MaxDB or the InnoDB table type of MySQL would be more appropriate than a MyISAM MySQL database instance. > 2. Fastest Loading of Data in Master Table > > Can I load data faster using MAXDB then with the standard MYSQL ? It depends. Loading data into a MyISAM database can't be beaten in time as there isn't all this transactional and concurrency handling stuff there ... Take care that due to the differences in the interfaces, you can't setup 'standard' MySQL replication directly between MaxDB and MySQL (you can possibly try to use the MySQL Proxy application for that). > > 3. Searching large tables based on Criteria ? > a. using index > b. use Set columntype > c. using Fulltext Search MaxDB has no SET datatype, and also no FULLTEXT indexing. Regards Alexander Schr�der SAP DB, SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
