Hi,
We have a problem : We are working with MySql ver 3.23.51 in Windows NT 4.0 Service Pack 6. We use Acctualy MyIsam. It works fine, SELECT works fast with any indexes ( primary and others ) But when try to use InnoDB, only the primary key works like MyIsam With another keys, the delay is the same that we work without index. this is my.ini file about InnoDB innodb_data_file_path = ibdata1:1000M:autoextend innodb_data_home_dir=d:\mysql\data\prueba set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = d:\mysql\data\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = d:\mysql\data\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 #skip-locking #set-variable = max_connections=16M #set-variable = record_buffer=1M #set-variable = sort_buffer=1M #set-variable = key_buffer=16M Can somebody help us, or tell us where we'll can solve this problem ? Thank you very much --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.380 / Virus Database: 213 - Release Date: 24/07/02 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php