On Wed, Apr 9, 2008 at 6:06 PM, Jeff Johnson <[EMAIL PROTECTED]> wrote:
> VFP tables work for me because they don't require a server like MSSQL > Server or PostGreSQL or even Advantage. I can't install any server or > programs where the data is stored. I use views and cursors that access > the data on the network drive for the data file server. Reasonable size > tables work fine, but tables over 30MB start to get unresponsive. > Backing up the tables takes a considerable amount of time also. > Splitting the tables seemed like a reasonable approach. > ------------------------------------------ That sounds terrible. You have target at 30 megs of data and you need to split for performance? Ask Charlie how to fix your design, because he has boasted about large systems in use befoe. >From my POV you need to bite the bullet and get a real server based system for your data. Nix or Win no matter. I know that sounds complicated and I'm sure that is going to be hell to implement. -- 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.
