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: 248733 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 22, 2009 6:07:58 PM         
   


> > if a file size of a table of dbf is 200 MB, and convert this in mssql database, Who will work speedy work? insert,update, search and in reports. thanks
>
> 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?

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