It sounds like you're suggestion something like Oracle does with PL/SQL, which I think is the better way to go. Then it's really up to the user to decide how to optimize multiple steps by creating a batch of commands to be run.

On Sunday, February 23, 2003, at 03:57 PM, Julian wrote:

 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.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


--------------------------------------------------------------------- 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



Reply via email to