At 14:52 2013-09-09, Jean Haidar <[email protected]> wrote:
one of our developer is experiencing long delays when running this
Select Statement
Select * from TableX where reccount() > 600000
This is a silly query. Let me translate it:
If TableX has more than 600000 rows, then return the entire
table; otherwise, return an empty table with the same structure.
Why do you need this?
I looked at table Record count under Data Session and it is showing
about 798,000 records.
as I understand that VFP uses Rushmore Query Optimization to Speed
Data Access for RECCOUNT
I would have thought that it would just look up in the header
for the number of rows.
For Rushmore to work, you need indexes.
Why the RECCOUNT comamnd is taking more than 10 minutes.
the tables are stored under Citrix Servers ( NAS) Directories..
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
