"Richard Doust" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Well, it's a complicated report used by a purchaser to generate a
> purchase order based on need for a product dependent on customer demand.
> It's accessing a LOT of data. That's not to say that I can't speed it up
Well, it's a complicated report used by a purchaser to generate a
purchase order based on need for a product dependent on customer
demand. It's accessing a LOT of data. That's not to say that I can't
speed it up with indexes, or break it up into a request that's passed
off to a server proce
I think the bigger question is why does it take that long to run? I can't
think of too many people that are willing to wait that long for information.
Personally I'd give you 30 seconds and then I'll never use something that
slow again.
If you are accessing data, try adding indexes or a data redes
