Oppz! Sorry for overlooking your timing method.
In this case, I believe if you run the query in four different machines
at the same time, the statistics should almost the same as running four
consecutive queries in the same machine.
I believe the multi-threading implemented in the JVM and the OS
AFAIK, creation of connection from DB is expensive. This is one of the
reasons why we need connection pooling.
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 . 2990 0174
FAX: 852 . 28249017
-Original Message-
From: Haitao J
Have you tried this: bin/safe_mysqld --user=mysql & ?
Or there is a script inside supporting called mysql.server, you can
start it up by typing mysql.server start
Hope this help!
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 . 299
Adrian,
You may try this:
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 . 2990 0174
FAX: 852 . 28249017
-