gt; Andrew
>
> -Original Message-
> From: Moon's Father [mailto:yueliangdao0...@gmail.com]
> Sent: 17 April 2009 06:36
> To: Manoj Singh
> Cc: php...@lists.php.net; mysql@lists.mysql.com
> Subject: Re: Is Temporary table right approach
>
> If you can not eli
d cause
his site
To die a miserable swappy death.
Andrew
-Original Message-
From: Moon's Father [mailto:yueliangdao0...@gmail.com]
Sent: 17 April 2009 06:36
To: Manoj Singh
Cc: php...@lists.php.net; mysql@lists.mysql.com
Subject: Re: Is Temporary table right approach
If you can not eli
If you can not eliminate your temporary tables, you have to adjust the
following parameters in my.cnf
[mysqld]
max_heap_table_size=1G
tmp_table_size=1G
On Fri, Apr 17, 2009 at 12:57 PM, Manoj Singh wrote:
> Hi All,
>
> Thanks for your valuable input.
>
> I have decided to use temporary table appr
Hi All,
Thanks for your valuable input.
I have decided to use temporary table approach. Since I am using it for the
first time and this has to be done in the production server. Do I need to
consider some facts before using this such as setting some parameters in
my.cnf etc or the MYSQL will handl
Use temporary table can be a good idea. But I think you performance would be
boost so much if you can do something else to replace the temporary table.
On Wed, Apr 15, 2009 at 2:03 PM, Manoj Singh wrote:
> Hi All,
>
> I have a query which returns the large number of ids which i am using in
> othe
Hi All,
I have a query which returns the large number of ids which i am using in
other queries. I am doing this in PHP. Now the first query can return
unlimited number of ids which might create problem in PHP. I want to store
this ids in MYSQL through temporary table so that i can access that ids
