Slow view requery

I have a parameterized view into a large MySQL table. When I requery the
view, control is immediately returned to the command window. The record
count for the view slowly increases at the rate of about 200 records a
second. Bandwidth consumption is minimal, cpu is minimal. If I check the box
the server is running on, I find that cpu on that box is also at a minumum.
This looks like something is throttling the query, because everything is
running at an idle. How can I:

1) Have control not return until the view is done being requeried
2) Have the system use max cpu/bandwidth instead of just idling along, so
that I can get my results faster?

Ook
Tue Jan 27 12:48:33 CST 2004

I can GOTO BOTTOM to force the rest of the records to come in right now - is
there a better way to force the view bring in all records immediately?


"Ook" <outlookexpress@nospam@embertsdotcom> wrote in message
news:e%23WtxUQ5DHA.2720@TK2MSFTNGP09.phx.gbl...
> I have a parameterized view into a large MySQL table. When I requery the
> view, control is immediately returned to the command window. The record
> count for the view slowly increases at the rate of about 200 records a
> second. Bandwidth consumption is minimal, cpu is minimal. If I check the
box
> the server is running on, I find that cpu on that box is also at a
minumum.
> This looks like something is throttling the query, because everything is
> running at an idle. How can I:
>
> 1) Have control not return until the view is done being requeried
> 2) Have the system use max cpu/bandwidth instead of just idling along, so
> that I can get my results faster?
>
>

Willianto
Tue Jan 27 13:11:49 CST 2004

Hi Ook:
Have you set the view's FetchAll property to -1?

hth,
Willianto

Ook wrote:
> I can GOTO BOTTOM to force the rest of the records to come in right
> now - is there a better way to force the view bring in all records
> immediately?
>
>
> "Ook" <outlookexpress@nospam@embertsdotcom> wrote in message
> news:e%23WtxUQ5DHA.2720@TK2MSFTNGP09.phx.gbl...
>> I have a parameterized view into a large MySQL table. When I requery
>> the view, control is immediately returned to the command window. The
>> record count for the view slowly increases at the rate of about 200
>> records a second. Bandwidth consumption is minimal, cpu is minimal.
>> If I check the box the server is running on, I find that cpu on that
>> box is also at a minumum. This looks like something is throttling
>> the query, because everything is running at an idle. How can I:
>>
>> 1) Have control not return until the view is done being requeried
>> 2) Have the system use max cpu/bandwidth instead of just idling
>> along, so that I can get my results faster?

Trey
Tue Jan 27 13:06:12 CST 2004

use dbsetprop to set the FetchSize to -1 (all records), the default is 100,
I believe

e.g., DBSETPROP("viewName", "VIEW", "FetchSize", -1)

"Ook" <outlookexpress@nospam@embertsdotcom> wrote in message
news:uPdQ$XQ5DHA.2392@TK2MSFTNGP11.phx.gbl...
> I can GOTO BOTTOM to force the rest of the records to come in right now -
is
> there a better way to force the view bring in all records immediately?
>
>
> "Ook" <outlookexpress@nospam@embertsdotcom> wrote in message
> news:e%23WtxUQ5DHA.2720@TK2MSFTNGP09.phx.gbl...
> > I have a parameterized view into a large MySQL table. When I requery the
> > view, control is immediately returned to the command window. The record
> > count for the view slowly increases at the rate of about 200 records a
> > second. Bandwidth consumption is minimal, cpu is minimal. If I check the
> box
> > the server is running on, I find that cpu on that box is also at a
> minumum.
> > This looks like something is throttling the query, because everything is
> > running at an idle. How can I:
> >
> > 1) Have control not return until the view is done being requeried
> > 2) Have the system use max cpu/bandwidth instead of just idling along,
so
> > that I can get my results faster?
> >
> >
>
>