Very fast data connection

[astech]

Hi all Expert,
I have much question that confusing me. It's about very fast and best data connection to include in my project.

1. What database to used (DBF,Access,SQL,Oracle or etc) ?
2. What connection to used ?
3. What a Trick to fast in using it ?
4. How to using in multiple user used it with no other user waiting while data in use by other user ?
5. and everything that link with my question.
6. If other than DBF is better, can u give me a little project for my learn, 'cause i'm never use other.

Thanks for u're advice.

 

[Mike Gagnon]

astech


1. What database to used (DBF,Access,SQL,Oracle or etc) ?


It all depends on what the project is for, how many users, LAN or WAN etc...But this is a FoxPro forum, so you may get a bias opinion.

2. What connection to used ?

This is unrelated to a VFP issue. But if the budget permits why not a dedicated DS3 (T3)?

The rest of your questions related to programming issues and your level of understanding "multiusers" applications. If you have this many questions in that area, you might be better hiring an external consultant you help you make those choices.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Astech,

I suggest you read the sections of the VFP help file on shared access. There is a lot of useful information there which will get you started.

Once you have done that, come back here with specific questions. Also, you'll get better answers if you ask each question is a separate thread.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[jimoo]

About a year ago, I had lunch with a group of techies, including a couple of senior MS consultants. One of the consultants stated that MS's fastest data access is VFP indexed tables. That certainly did not surprise me.

However, like every computer question, the answer is it depends on what you are doing, and what do you need the database to do for you.

The network, for example, is usually the weakest link when it comes to data access. Since FoxPro queries can send a lot of data across the network, a slow connection will make it appear VFP is running slowly.

SQL server sends less data across the network. You send a request, the server chews it up, then spits out the results.





Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[Mike Lewis]

Jim,

One of the consultants stated that MS's fastest data access is VFP indexed tables.

Doesn't surprise me either.

However, SQL Server will often be faster if you take total throughput into account. That's simply because SQL Server is a true client-server system; a SQL Server query will usually result in less network traffic than the same query from VFP on a file server.

But, I agree that in terms of pure processing speed, VFP is hard to beat.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk