45 seconds to create 120 000 MyISAM table char rows? Thats a pretty nifty speed. PHP have a considerable overhead compared to new versions of Java. (I use both languages... I prefer PHP for webpage generation, but Java for serverside applications)
I am hesitant to dig into C++ just to solve this problem, so I am as far as possible trying to solve the performance issues within Java and MySQL. I will probably rewrite the code countless of times just to see if I can do it, and last resort would be C++. In this case I believe MySQL will be faster to use than i.e. making an Array of 200 000 entries, and do manual searches. (Somebody prove me wrong, but I believe the MySQL crew have far better preferences to make a query-search-update system than I have preferences to make a huge Array to serve the same purpose, right?) If the MySQL database can create a HEAP table with only numbers stored directly in memory, and do a recursive search with 10 subqueries for every 1 record query (200 000 records in all) within 1 minute, then I'll be happy :) The remaining 1 minute I'll permit for Java and system overhead :) Cheers Rob. -----Mensagem original----- De: Peter Lovatt [mailto:[EMAIL PROTECTED]] Enviada em: domingo, 6 de outubro de 2002 19:26 Para: [EMAIL PROTECTED] Assunto: RE: Performance Question. 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 ______________________________________________________ Se den nye Yahoo! Mail på http://no.yahoo.com/ Nytt design, enklere å bruke, alltid tilgang til Adressebok, Kalender og Notisbok --------------------------------------------------------------------- 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