At 10:47 PM 11/23/2006, John Kopanas wrote:
That is awesome... thanks. I still am not sure exactly though why
this take 2 seconds while my methond took over a minute for the same
amount of rows. In essence don't the two methods do the same things?
No. Your approach was executing the subquery
At 09:47 PM 11/23/2006, John Kopanas wrote:
That is awesome... thanks. I still am not sure exactly though why
this take 2 seconds while my methond took over a minute for the same
amount of rows. In essence don't the two methods do the same things?
The Group By executes in one operation. I may
That is awesome... thanks. I still am not sure exactly though why
this take 2 seconds while my methond took over a minute for the same
amount of rows. In essence don't the two methods do the same things?
On 11/23/06, mos <[EMAIL PROTECTED]> wrote:
At 05:50 PM 11/23/2006, you wrote:
>I have the
In the last episode (Nov 23), John Kopanas said:
> I have the following query:
>
> UPDATE companies c
> SET
>total_annual_service_charge =
> (
>SELECT SUM(annual_service_charge)
>FROM purchased_services ps WHERE ps.company_id = c.id
> );
At 05:50 PM 11/23/2006, you wrote:
I have the following query:
UPDATE companies c
SET
total_annual_service_charge =
(
SELECT SUM(annual_service_charge)
FROM purchased_services ps WHERE ps.company_id = c.id
);
It takes 1s to run when I ha
I have the following query:
UPDATE companies c
SET
total_annual_service_charge =
(
SELECT SUM(annual_service_charge)
FROM purchased_services ps WHERE ps.company_id = c.id
);
It takes 1s to run when I have two tables of 500 rows, 4s with t
Hi,
I'm currently looking at te best way to do a master switch in a
replication setup (4.1).
Let's say I'm switching from M1 to M2. I'm looking particularly at the
different possible way to hold the query (Write) on the M2 server till
I can check that the replicate was done playing the
Hi friends,
I need to create an application where i will be requiring a backup server
like when one server fails i can switch automatically to the other server
hosted somewhere else , now the data needs to be consistent on both the
servers, one sol is i keep automated backups on the primary server
Hello Jerry,
I can give you the shema of my "parent" table:
CREATE TABLE `demo_employee` (\n `idemployee` int(10) unsigned NOT NULL
auto_increment,\n `demo_mandt_idmandt` int(10) unsigned NOT NULL default '0',\n
`demo_adress_idadress` int(10) unsigned NOT NULL default '0',\n
`demo_adress_demo_re
Hi
I've followed the replication procedure, as instructed on the online
manual.
I want to use replication over SSL.
I've followed this procedure to create test SSL certificates, keys, etc.
http://dev.mysql.com/doc/refman/4.1/en/secure-create-certs.html
On slave machine:
mysql> show slave statu
Hi,
I am trying to use stored functions through the prepared statement C API. I
have one application that issues relatively long running queries, while the
other is doing some inserts, updates, and short queries. If the second
application somehow calls a stored function (either directly through
11 matches
Mail list logo
