Re: Re: Avoiding roundtrips

2001-04-06 Thread Tomas Eriksson

Thanks for your answers,

Sorry for not being clearly...i mean like select into temporary/select into another 
temp/select the result from these in just one "sql-string". I tried separating with 
both ; and \n but it complains about syntax error near this. I thought that doing 5+ 
or something separate query-executions could take down the perfomance. I'm using Perl 
DBI.

kinds regards
Tomas

- Original Message - 
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 1:52 PM
Subject: Re: Avoiding roundtrips


> Tomas Eriksson writes:
>  > Hi.
>  > 
>  > I guess we all are waiting for subselects in Mysql...but can you do many 
>  > sql-commands in a single execution, with a nice finally-result-select at 
>  > the end? Many roundtrips feels bad...
>  > 
>  > kind regards
>  > Tomas
> 
> 
> I truly do not understand what feature are you looking for.
> 
> You can always build multithreaded client with C++ or Perl.
> 
> 
> Regards,
> 
> Sinisa
> 
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team
> 
> -
> 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
> 
> 


-
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




Re: Avoiding roundtrips

2001-04-06 Thread Sinisa Milivojevic

Tomas Eriksson writes:
 > Hi.
 > 
 > I guess we all are waiting for subselects in Mysql...but can you do many 
 > sql-commands in a single execution, with a nice finally-result-select at 
 > the end? Many roundtrips feels bad...
 > 
 > kind regards
 > Tomas


I truly do not understand what feature are you looking for.

You can always build multithreaded client with C++ or Perl.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
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




Avoiding roundtrips

2001-04-05 Thread Tomas Eriksson

Hi.

I guess we all are waiting for subselects in Mysql...but can you do many 
sql-commands in a single execution, with a nice finally-result-select at 
the end? Many roundtrips feels bad...

kind regards
Tomas