Gureumi and Bill gave me useful information - thank you! I have described the environment where my application lives and that I can't change it. I have a job because I can work in these environments. One of two major problems is that I can't install any data servers on the data file servers and I don't want to deal with the corporate dba's in order to use MS SQL Server. The second major problem is a 256k network with five to ten users on an intranet. During peak use the network can be very slow.
Reasonable size files work just fine in this environment and this is just for one customer that does everything on a monthly basis. They are planning on upgrading their network connections in the future but I can't wait for that because they are dependent on the application now. Jeff Jeff Johnson [EMAIL PROTECTED] SanDC, Inc. 623-582-0323 Fax 623-869-0675 Stephen Russell wrote: > 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. > > _______________________________________________ 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.
