Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query (select/insert/update)Slows when table grows
Thanks for your help and advice. Sorry for this late reply. Actually I was busy in Upgrading to latest MySQL(4.1.14)version and get the latest JDBC connector. And my program's performance has improved dramatically. I was using 4.0.* version which was quite outdated. Now all is fine and query is... -
Query (select/insert/update)Slows when table grows
I have tried that too. I have created index on Primary Key! And that slows down the process. I found that update operation for some tokens(primary key) takes almost 100ms after rows grow over 120,000. Do you think a primary key varchar(255) can be problem? If so should I change the Table design? -
Query (select/insert/update)Slows when table grows
Hi All, I have a mysql database where tables are very simple. An example table will look like this: create table myTable( token varchar(255) not null primary key, token_count int default 1, frequency int ) type=INNODB; A java program populates this table. The program reads from files (in... -
Different kinds of Perl subroutines
Hello All, I'm a newbie in the Perl. I'm encountering a bit of difficulty understanding various methodology in subroutine calls. Can any one describe the arguments that are getting passed? Pattern 1: (most common) sub mysub{ } Comments: Understood -------------------------------------...
