Speed improvement with packet proceeding!? I'm not quite sure is it possible with Mysql but it could be "easy" to be implemented. For example:
select * from table where id=52 and name='some' select * from table where id=23 and email='[EMAIL PROTECTED]' these two queries select row(s) from table 'table' which means that these two queries could be tested simultaneously, so database file will be proceed only once. As the way bulk insert (i.e muliple insert) achieve significant speed improvment such thing could happend to selects too. However Mysql use cache so some kind of improvement is already available, but if selected rows are too many cache will not help. So could these two (or more) selects to be proceed together (like packet)? In fact I'm not talking only about 'select'-s but any tables examination/traverse (i.e where clauses etc..), so queries like these could be also speed up: update table set data='test' where name='some' select * from table where id=10 Any ideas and discussion about this? __________________________________________ 12MB-POP3-WAP-SMS-AHTИCПAM--TOBA-E-mail.bG ------------------------------------------ HOB БEЗПЛATEH AДPEC - http://mail.bg/new/ ------------------------------------------ --------------------------------------------------------------------- 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
