All the web service does is insert the data into the database. It loops over the array and inserts each structure, currently uses a stored procedure to insert them but only because was seeing if that would have any effect on performance(did not think it would but was grasping at the time). All the SP is, is an SQL insert statement. It returns nothing, has a returntype of void.
The page is something they have been using here for years on CF5. It essentially copies LDAP into their database nightly. As I said, I hate having to support this thing, I would never have even considered using CF to copy 67k or so records nightly from LDAP into one of my databases.
On 3/9/06, Nolan Erck <[EMAIL PROTECTED]> wrote:
----------------------------------------------------------What does your webservice/component do? Since you're calling it over and over again in the loop, are the values it's returning things that you could cache, or stick into a lookup table, or some otherwise rewrite of the insides to that method)? Maybe that would speed things up as well.
I assume you've profiled the page somehow, and are certain you're looking at the "problem code area", yes?
Just something else to check…
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
