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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by michaeljiang

  1. michaeljiang

    Extreamly Slow Search?

    select count(*) from pictureinarticle as pa inner join article as a on a.id=pa.articleid where a.timestamp between START and END Thanks! In fact, I've also tried this and the following: select count(*) from pictureinarticle pa, article a where pa.articleid=a.id and a.timestamp between START...
  2. michaeljiang

    Extreamly Slow Search?

    I have the following 2 tables table pictureinarticle{ 'id' int(10) unsigned NOT NULL auto_increment, 'articleid' int(10) unsigned NOT NULL, 'pictureid' int(10) unsigned NOT NULL, PRIMARY KEY ('id'), KEY 'pictureid' ('picutreid', 'articleid') } table article{ 'id' int(10) unsigned NOT NULL...
  3. michaeljiang

    Slow module problem?

    Solved finally. In the while loop (in "new" of "A.pm"), I used regular expression to look for certain patterns. Unfortunately, in "B.pm", "English" module is used and that was included long time ago for test purpose (yes, unfortunately, it is still there, BAD:( and I didn't notice it twice for...
  4. michaeljiang

    Slow module problem?

    Forgot to mention, in "new" of A.pm, it first opens a file and read all lines into a variable ONCE. Then it has a while loop to iterate all lines to do some processing. It is this while loop that cost that long time.
  5. michaeljiang

    Slow module problem?

    I have a class moduel A.pm, a non-class module B.pm and a console file C.pl. This is relationship of these 3: C.pl "use B;" B.pm "use A;" and "new A();" In "new" of A.pm, I have some codes to read a file for about 240000 lines. But it took extremely long time ( more than 5 minutes!) for A.pm...
See more

Part and Inventory Search

Back
Top