On Mon, Sep 8, 2008 at 6:53 AM, NickC <[EMAIL PROTECTED]> wrote: >> Stephen Russell wrote: >> >> how many indexes on Ordno? >> >> Why not make a fake table to hold just the orders for the past ??? 180 >> days perhaps. >> >> Now your NEXT or Prev. navigation will give you the actual value you >> then do your query for. >> > > Stephen, > >> how many indexes on Ordno? > > Have tried various combinations but now only one. > > It is just as if once the table goes beyond a certain size Rushmore stops > using the indexes properly and downloads the whole table instead, even > though SYS(3054) still claims full Optimization. > > If I shrink the table to only a few fields wide length the speed is > immediate, even with the 100K records. > If I shorten the table to 10K records the speed is immediate, even with 200 > fields wide. > > However if the table is both 100K records long and 200 fields wide Rushmore > just seems to fail. ------------------------------------
Is this table in a join perhaps? Could you add a new column to the table and make it a GUID? then fill it? Or is this a very old FP app and that is not available? You have re-indexed the column right? The index is just the pointer, so make a different one for the POINT, and keep the existing one for the show and reference to all other tables. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
