Is your MSSQL data structure contain such foreign key?
If yes, my isam is not suitable for you Others... for overall, i prefer innodb :) On 10/8/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
