Speed improvement with packet proceeding!? 1. 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 2. Bulk update/delete etc.. Take a look at this update query (not implemented.. yet!) update table1 set column=value,... where clause limit #, update table2 set .... (or delete from table1 where clause limit rows, delete from table2 where clause...) It is something similar to INSERT ... VALUES (),(),().... Ok, how this can help? Take a look at this example: update DEMO_TABLE set ID=$new_id where ID=$id, update DEMO_TABLE set CID=$new_id where CID=$id Here we searching by $id, but in quite different fields (for example related categories application), BUT we need to update different fields i.e. we need different SET! Note that DEMO_TABLE is the same table for both updates. By now (with two separate queries) Mysql server *need* to exam db unefficiency twice! Using new query style, Mysql will need to exam db only once! Have I a good point here? Any ideas and discussion about these suggestions? __________________________________________ 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
