On Thu, Apr 10, 2008 at 9:50 AM, Jeff Johnson <[EMAIL PROTECTED]> wrote:
> 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. > ----------------------------------------------------- I find this a standard out there as a hurdle "and I don't want to deal with the corporate dba's in order to use MS SQL Server. " I don't get why, is it that you don't 1) Want to talke to them 2) Understand what they are saying 3) Understand the implications 4) Know how to write change scripts 5) Know how to index data properly 6) How to fix broken queries 7) how to update data that isn't xBase 8) heck I could go on....... If they have a REAL database then it is in your better interest (financially that is) to learn how to work with the people that are doing that for the company today. I'm sure that if you told them the first part of this thread they would seriously look at your value to the team. Sorry but any news that you "can't do what others are doing" just puts a target on your back. the network could be slow because of DBF and CDX traffic. I remember putting a sniffer on our network at Baker Donnelson when my reporting app was putting together huge reports, 1400 page average at the time. My good friend was the CNE so he could talk to me directly on how brutal the FPW app was. That was 95-98 but I don't think that much has changed in reality for dbf usage when tables are stored on the network, and the exe is run locally. > 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. > ---------------------------------------------- Can you tell us what a reasonable size file is in megs please. That will help us all in aiding you. If you need some pointers on working with M$ Sql data I'll do whatever I can to assist you. I did this a number of times from FPD, FPW, VFP5,6,7 I can help you work with your dba(s) so your stuff is usable as well as performing at it's best. -- 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.
