It was recommended that i visit here, to get my code optimised.

Are people here willing to do an optimisation?

Ill post code if anyone is up for it!!

Thanks in advance

Not really "doing" but rather "suggesting how YOU could optimize".

My first suggestion would be to actually measure where your time budget is
spent so that you can invest your time on optimizing the relevant parts and
have a measurable feed back on your changes...

--
Patrice

"poop" <poop@poop.com> a écrit dans le message de
news:u8pu1kMAGHA.3864@TK2MSFTNGP12.phx.gbl...[color=blue]
> It was recommended that i visit here, to get my code optimised.
>
> Are people here willing to do an optimisation?
>
> Ill post code if anyone is up for it!!
>
> Thanks in advance
>
>[/color]

Im pulling records from a database 1 at a time and then creating an email,
which is sent via a persits email module on the server.

The problem is that some accounts require the page to send several thousand
cards. This cycle is causing the server to time out on this page.

I need to make tihs process quicker.

"Patrice" <nobody@nowhere.com> wrote in message
news:e9HzAqMAGHA.3584@TK2MSFTNGP14.phx.gbl...[color=blue]
> Not really "doing" but rather "suggesting how YOU could optimize".
>
> My first suggestion would be to actually measure where your time budget is
> spent so that you can invest your time on optimizing the relevant parts
> and
> have a measurable feed back on your changes...
>
> --
> Patrice
>
> "poop" <poop@poop.com> a écrit dans le message de
> news:u8pu1kMAGHA.3864@TK2MSFTNGP12.phx.gbl...[color=green]
>> It was recommended that i visit here, to get my code optimised.
>>
>> Are people here willing to do an optimisation?
>>
>> Ill post code if anyone is up for it!!
>>
>> Thanks in advance
>>
>>[/color]
>
>[/color]

Quit sending them one at a time. Add the other recipients to the CC or BCC.

Or, better still, use a real list server.

BTW - The way you're doing it, the bottleneck is probably not ASP or the
component. It's more likely the mail server.

Bob Lehmann

"poop" <poop@poop.com> wrote in message
news:eWDaf7cAGHA.2704@TK2MSFTNGP15.phx.gbl...[color=blue]
> Im pulling records from a database 1 at a time and then creating an email,
> which is sent via a persits email module on the server.
>
> The problem is that some accounts require the page to send several[/color]
thousand[color=blue]
> cards. This cycle is causing the server to time out on this page.
>
> I need to make tihs process quicker.
>
> "Patrice" <nobody@nowhere.com> wrote in message
> news:e9HzAqMAGHA.3584@TK2MSFTNGP14.phx.gbl...[color=green]
> > Not really "doing" but rather "suggesting how YOU could optimize".
> >
> > My first suggestion would be to actually measure where your time budget[/color][/color]
is[color=blue][color=green]
> > spent so that you can invest your time on optimizing the relevant parts
> > and
> > have a measurable feed back on your changes...
> >
> > --
> > Patrice
> >
> > "poop" <poop@poop.com> a écrit dans le message de
> > news:u8pu1kMAGHA.3864@TK2MSFTNGP12.phx.gbl...[color=darkred]
> >> It was recommended that i visit here, to get my code optimised.
> >>
> >> Are people here willing to do an optimisation?
> >>
> >> Ill post code if anyone is up for it!!
> >>
> >> Thanks in advance
> >>
> >>[/color]
> >
> >[/color]
>
>[/color]

Though you could alter this setting it's likely better :
- as suggested in another thread optimize the process itself (by using
CC/BCC)
- another thing to try would be to use the filesystem rather than passing by
COM (for example some components are able to process files that are put in
their "pickup" directory, it could be quicker)

Finally, for these kind of things, it's likely better to process this
asynchronously i.e. the ASP page just queues the tasks to be done and
another process processes theses tasks (could be as scheduled application, a
SQL job etc...).

--
Patrice

"poop" <poop@poop.com> a écrit dans le message de
news:eWDaf7cAGHA.2704@TK2MSFTNGP15.phx.gbl...[color=blue]
> Im pulling records from a database 1 at a time and then creating an email,
> which is sent via a persits email module on the server.
>
> The problem is that some accounts require the page to send several[/color]
thousand[color=blue]
> cards. This cycle is causing the server to time out on this page.
>
> I need to make tihs process quicker.
>
> "Patrice" <nobody@nowhere.com> wrote in message
> news:e9HzAqMAGHA.3584@TK2MSFTNGP14.phx.gbl...[color=green]
> > Not really "doing" but rather "suggesting how YOU could optimize".
> >
> > My first suggestion would be to actually measure where your time budget[/color][/color]
is[color=blue][color=green]
> > spent so that you can invest your time on optimizing the relevant parts
> > and
> > have a measurable feed back on your changes...
> >
> > --
> > Patrice
> >
> > "poop" <poop@poop.com> a écrit dans le message de
> > news:u8pu1kMAGHA.3864@TK2MSFTNGP12.phx.gbl...[color=darkred]
> >> It was recommended that i visit here, to get my code optimised.
> >>
> >> Are people here willing to do an optimisation?
> >>
> >> Ill post code if anyone is up for it!!
> >>
> >> Thanks in advance
> >>
> >>[/color]
> >
> >[/color]
>
>[/color]

Patrice wrote:[color=blue]
>
> Finally, for these kind of things, it's likely better to process this
> asynchronously i.e. the ASP page just queues the tasks to be done and
> another process processes theses tasks (could be as scheduled
> application, a SQL job etc...).
>[/color]
http://www.aspfaq.com/show.asp?id=2143
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"