in reply to Re: Parsing a lot of data. Very slow. Need suggestions
in thread Parsing a lot of data. Very slow. Need suggestions

its not the same command, because the $date variable gets changed each time the process is called. in this case here, its 120 dates. 120 different commands. and then 120 more, for another similar command. they need to be in a loop. :)
  • Comment on Re: Re: Parsing a lot of data. Very slow. Need suggestions

Replies are listed 'Best First'.
Re: Re: Re: Parsing a lot of data. Very slow. Need suggestions
by Ryszard (Priest) on Aug 16, 2002 at 14:09 UTC
    use place holders. There is a lot of overhead in your rdbms reparsing an sql statement...