RE: simple question on WHERE SELECT query

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 -

RE: getting mysql working

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

RE: Idea to speed up multiple jdbc connections?

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

RE: Idea to speed up multiple jdbc connections?

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