>>>>I am pulling down several large tables from an Oracle database and was wondering if anyone has come up with a means of showing the progress for this sort of operation. I have tried the "timer" route but it looks as if the timer events get put into the queue as the "SELECT" query eats up the cpu time. Any ideas?
>>>>
>>>>Thanks,
>>>>George
>>>
>>>Hi George,
>>>
>>>You can show an AVI before you start your query and shut it down after it finishes. It doesn't give you a progress bar, but at least the user has some idea the program is still busy doing something. I've used a AVI called transmit.avi (think it comes with VS) that shows two computers connected through a pipe and a little red ball comes back and forth between them.
>>>
>>>The other thing is to run the SPT asynchronously, set the number of records to bring at a time and do something in between the packs. It turns out to be the same deal as with the AVI, because in either case you don't know how many total records are coming to show a progress bar. Unless you're doing a "TOP nnn" query.
>>>
>>>Fancy meeting you here. Hope you're doing good.
>>
>>Hey Crescencio, how are you?! Small world, eh? Hope things are going well. And that wold probably be the easiest route. I like the idea. Thanks!
>>
>>George
>
>I'm doing OK, thanks for asking. Still hanging around here as you can see.
>
>I noticed you changed jobs. I'm sure it was for the better.

Hehe, hope they are treating you ok. Have heard it has been pretty bad over there. And yup, changed jobs. Actually, I got laid off from ATX along with about 100 other people. Doesn't look like they are doing too well :(