Hi all, I'm planning to run a remote DB across the internet for a web application and I would like to minimize retrival times and bandwidth.
I have a couple of questions about MyISAM compressed Tables: 1. Is it slower to retrieve from a compressed table, or actually faster since data is packed? 2. Is there an increase in CPU overhead? Is it significant? 3. Is the data sent to the client compressed or decompressed? As for indicies is it better to create a single index per column, or an index for a set of columns. For example, if I go: SELECT * FROM SOMETABLE WHERE A = X and B = Y. Is it better to create a X AND Y index, or two separate indicies? Thanks! sql, query, mysql, stuff to avoid the spam filter... -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ --------------------------------------------------------------------- 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
