I'm just curious as to which would have better performance for my needs. backend is a MSSQL server and I want to replicate it into a MySQL Frontend for user accesses.
replication would be done via "mysqlimport/load data infile". I'm thinking of doing the inserts something like ever 5 seconds or so. MyISAM tables are faster than InnoDB, but they are more optimised for READS than WRITEs, however due to the replication, (being done every 5 secs on ~5 tables), I'm wondering if this will cause performance losses due to table-locks etc. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
