Hi Just did a quick test using phpMyAdmin
INSERT INTO `db`.`speedtest` SELECT * FROM `db`.`table1` These are just standard MyISAM tables The query creates about 120,000 rows and 5 indexes on CHAR fields in 45 seconds so you should be fine if MySql does the work. If you have a lot of Java manipulation as part of the process then you need to allow for that, if not your system should walk it. HTH Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net tel. 0121-242-1473 ----------------------------------------------- -----Original Message----- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: 06 October 2002 21:08 To: Peter Lovatt; Robert H.R. Restad; [EMAIL PROTECTED] Subject: RE: Performance Question. > I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run > queries on datasets of 220,000 > > SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time > than I can count (0.1 sec at a guess) > > The insert/update bit is the bit which will dictate the speed - how many > records need updating? Don't forget the considerable overhead of PHP itself. sql, query --------------------------------------------------------------------- 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
