List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:May 28 1999 5:11pm
Subject:Re: Mysql.pm error Resource Temporarily Unavailable
View as plain text  
Dan Ray wrote:
> $dbh->errstr? Further, does anyone have any thoughts about why this process
> is so agonizingly slow?
> 

Inside your loop, are you connecting and disconnecting to the DB each
time. If so, move the connection outside the loop this would help
alot!!!

Also, depending on MySQL's version you can do multi-inserts with on
query:
INSERT INTO Products
(DEPARTMENT_NO,CLASS_NO,PRICE,SKU,DESCRIPTION,DEPARTMENT,CLASS,UNIT
,FINE_LINE_CLASS_NO,CODE,ID,FINE_LINE_CLASS,) VALUES
('17.00','170.00','0.08','6309.00','1x2 Furring R/L','Common
Lumber','Furring, Woodlath & Misc.
Items','LF','1701.00','qjix7843','20292','Furring Strip'),
('17.00','170.00','0.08','6309.00','1x2 Furring R/L','Common
Lumber','Furring, Woodlath & Misc.
Items','LF','1701.00','qjix7843','20292','Furring Strip'),
('17.00','170.00','0.08','6309.00','1x2 Furring R/L','Common
Lumber','Furring, Woodlath & Misc.
Items','LF','1701.00','qjix7843','20292','Furring Strip')

  jim...

PS. how are you getting your scripts to the server, FTP or PUT?
Thread
Mysql.pm error Resource Temporarily UnavailableDan Ray28 May
  • Re: Mysql.pm error Resource Temporarily UnavailableSasha Pachev28 May
  • Re: Mysql.pm error Resource Temporarily UnavailableJim Faucette28 May
    • RE: Mysql.pm error Resource Temporarily UnavailableDan Ray28 May
      • Re: Mysql.pm error Resource Temporarily UnavailableChristian Mack28 May
  • Mysql.pm error Resource Temporarily UnavailableMichael Widenius2 Jun