On Mon, Mar 24, 2008 at 11:43 AM, Charlie Coleman <[EMAIL PROTECTED]> wrote:
> At 10:06 AM 3/24/2008 -0500, Stephen Russell wrote: > >On Mon, Mar 24, 2008 at 9:54 AM, Mike yearwood <[EMAIL PROTECTED]> > >wrote: > > > > > Hi David > > > > > > FoxPro never brings down the whole table. Although, if you have SET > > > DELETED ON and lots of deleted records, it may take time to skip over > > > those. > >------------------------------------------------ > > > >Are you sure? You need the entire index and depending on how you > specified > >your request, you are going to get the WHOLE TABLE. All of your > processes > >are acted upon locally, not on a server. So how do you not get your > entire > >table? > > <sigh> Steve, you still pushing your BS? > > No, VFP does not bring down the whole table. Unless of course you request > the whole table (e.g. SELECT .... FROM ... WHERE 1 = 1). > > For all practical purposes doing a USE <table>.... does not bring down the > whole table. The only exceptions I've seen to this is where the total > table > size was small. I can't remember what the cutoff was. Maybe 64k? Even > then, > since it's so small it's not really noticed. But my gigabyte-size tables > open in blip of time over a 100Mbps network. > -------------------------------------------------------------------------------- Charlie if your query is doing a tablescan then you have to have the table? No? >From tuning SQL Server or Oracle or mySQL querys your going to hit a table scan more often then you think. Because those are now local and all in ram they go rather quickly. But your indexes have to be spot of to not get caught in the dreaded table scan. Rushmore doesn't' combine indexes for joins and then for where clause. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
