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: 248730 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 22, 2009 5:50:53 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

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