Mary, you could try downloading MySQL-Max-3.23.52 for Windows and converting your tables to the InnoDB format.
Your tables maybe take some 500 MB of space in InnoDB. If you have a reasonably big Windows server with > 500 MB RAM, they will fit completely in the buffer pool if you configure it big enough. Windows has inefficient file cache management. When you get the data into the InnoDB buffer pool, you bypass that problem. Below you can check appropriate settings for your my.cnf or my.ini. http://www.innodb.com/ibman.html#InnoDB_start [mysqld] # You can write your other MySQL server options here # ... # Data file(s) must be able to # hold your data and indexes. # Make sure you have enough # free disk space. innodb_data_file_path = ibdata1:10M:autoextend # Set buffer pool size to # 50 - 80 % of your computer's # memory set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M # Set the log file size to about # 25 % of the buffer pool size set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M # Set ..flush_log_at_trx_commit # to 0 if you can afford losing # some last transactions innodb_flush_log_at_trx_commit=0 Regards, Heikki Innobase Oy ...................... it was a limitation of the DBTOOLS table manager... I am indexing right now using alter table... -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 1:08 PM To: Mary Stickney Cc: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED] Subject: Re: MySQL vs. Oracle (not speed) In the last episode (Aug 16), Mary Stickney said: > looks to me like I can only make indexes on fields that are not > null... this one is not , not null Indexing of NULL columns went into Mysql 3.23.2 (Dec 16, 2000). With tables this large, you might also want to raise some of the cache parameters in my.cnf . http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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
