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


> >
>
> > 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

Bernard Bout thanks

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