Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 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: 248773 # Views: 1 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 8:37:06 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?

Actually I would recommend a backend database, not because of speed but because of security and reliability. You can get free backends which do not have a limit on database size by going in for something like PostgreSQL or MySQL.

Regards
Tushar

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