Re: Row Count

Yes but surely the count hits function just goes back to the database to count the number of rows it will return. What you could do would be to store some sort of profiling information on the queries, tables etc. If you knew how many rows a table contained and which columns used indexes and how previous queries performed you might be able to predict how many rows a query would return. I'm not sure how feasible this is but you might be able to use it to identify large queries.

Dean.

In article <6b36q0$55t_at_bgtnsc03.worldnet.att.net>,   "Sameer Mahajan" <sameerm_at_worldnet.att.net> wrote:
>
> Hi Bill,
>
> In case ur front end is Forms u might like to make use of
> Count hits. This would give u the number of rows the query is
> going to retrive if executed plus the user can check that out
> with all the different conditions before actually executing.
>
> HTH
>
> Sameer Mahajan
> sameermj_at_usa.net
>
> Bill Bollhorst <bbollhorst_at_erols.com> wrote in article
> <34D41FEE.5AB8_at_erols.com>...
> > The project I am currently working on has a requirement to provide
> > feedback to the user about the query that (s)he has sent. This
> > feedback consists of the number of rows that satisfy the query and
> > the amount of time to satisfy the query.
> >
> > The customer's idea is that if the user sends a large query and
> > they are informed about it ASAP, they can take action to abort the
> > query or let it run in the background.
> >
> >
> > Personally I laughed when I saw these. :-) How do you get the
> > number of rows and/or time without actually doing the query?
> > If you are going to waste the time counting the rows, just
> > do the query.
> >
> > If there is an answer or a compromise to address this type of
> > requirement I would appreciate an opinion.
> >
> >
> > Thanks in advance,
> >
> > Bill
> >

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet