Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: khubaib khalid
  Where is khubaib khalid?
 HaroonAbad
 Pakistan
 khubaib khalid
 Tags
Subject: RE: which will speedy? mssql tables or vfp d
Thread ID: 248718 Message ID: 248760 # Views: 2 # Ratings: 8
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 2:40:24 AM         
   


> >
> > 200 mb is nothing. VFP tables on a local machine, will always be faster especially for this size of table. If proper indexes are used VFP will be extremely fast.
> >
> > SQLServer only comes in where the table is huge but there is a price attached to SQLServer.
> >
> > Bernard
> >
> > ** If you see someone without a smile, give em one of yours :) **
> > My Blog
>

> thanks Bernard, Is express ver of mssql is not free?

The point is if you have purchased VFP then VFP tables are also free. For a single table of 200 MB it makes no sense to use SQLExpress, even if the table doubles or triples in size. Even then VFP is capable of reading/writing data to/from it very very fast. And also does not suck up memory.

SQLExpress is indeed "free". However it has some limits. You can read about it here:

http://msdn.microsoft.com/en-us/library/ms345154%28SQL.90%29.aspx

The point a large number of DEV's miss about VFP and SQLServer is that VFP has a 2GB file limit and SQLServer express has a 4GB limit. The keyword here is FILE.

SQLSERVER stores all its data in a single file (MDF) and this is limited to 4 GB. Period.

However there is something hidden in that above statement that most advocates of SQLServer Express do not realise.

The database is limited to 4GB. This means that the total sum of the SP,Triggers, code and ALL other database stuff + ALL THE TABLES + ALL the Indexes - everything - is limited to 4GB.

VFP stores its database, indexes, tables in separate files and in the case of a table with a memo field in 2 separate files. EACH OF THESE FILES have a 2 GB limit.

Now with VFP since each file is limited to 2 GB. in doing a comparison with VFP and the "FREE" sqlexpress this has to be taken into account.

So if you have a VFP database, with 50 tables and 200 indexes, you can realistically have a total of

50 * 2 = 100 GB
200 * 2 = 400 GB

Think about this carefully and do the numbers.

and this is not the topmost limit. The only limit is that each individual file cannot exceed 2 GB.

So if you plan your design there really is no size limit as such.

So now when you compare VFP and "Free" SQLExpress , VFP can have > 500 GB as a database size (a really huge amount) whereas SQLExpress can only have 4 GB of data. And that is for a small to medium size application, a size ratio of 1: 125!!!

A number of companies also used to chain the VFP tables together giving even more data size.

You are not restricted to 1 GB of memory with VFP like you are with express. There are some other restrictions.

On a local computer you need a reasonably powerful computer to use SQLExpress with heaps of memory.

While there are some advantages in that with security and power failures, SQL is better, but if you think that your database - and this means ALL FILES related to data - will ever exceed 4 GB then think very carefully as the jump from "FREE" to licenses is quite huge.($$$)

Databases tend to fill fast and you could find yourself with a "NOT SO FREE" database system very quickly with the only option of shelling out for licenses.

Be warned that this is true in everything in life, not just databases:

"If it is too good to be true, then it probably is"

Free is not Free. You pay for what you get. MS are kings in marketing and know how to put their hook into you. Once hooked .....

nuff said


Bernard

** If you see someone without a smile, give em one of yours :) **
My Blog

ENTIRE THREAD

which will speedy? mssql tables or vfp d Posted by khubaib khalid @ 12/22/2009 3:32:33 PM
RE: which will speedy? mssql tables or vfp d Posted by Bernard Bout @ 12/22/2009 5:50:53 PM
RE: which will speedy? mssql tables or vfp d Posted by khubaib khalid @ 12/22/2009 6:07:58 PM
RE: which will speedy? mssql tables or vfp d Posted by M. Akram Bhatti @ 12/22/2009 6:14:42 PM
RE: which will speedy? mssql tables or vfp d Posted by khubaib khalid @ 12/22/2009 6:36:23 PM
RE: which will speedy? mssql tables or vfp d Posted by Bernard Bout @ 12/23/2009 2:40:24 AM
RE: which will speedy? mssql tables or vfp d Posted by khubaib khalid @ 12/23/2009 7:16:56 AM
RE: which will speedy? mssql tables or vfp d Posted by tushar @ 12/23/2009 8:37:06 AM
RE: which will speedy? mssql tables or vfp d Posted by Camil Ghircoias @ 12/23/2009 5:30:40 PM