Why MSSQL ?

[FoxWing]

Experts,

From day 1 when i use Foxpro, i know its database engine is very fast. However, when people heard of Foxpro database, they look down on it. All in their mind is MSSQL.

I'm pondering, if Foxpro database engine is so fast and powerful, then why people use MSSQL as the back-end for Foxpro application ?

Thanks.

 

[rgbean]

Scalability, security, backups, data mining, but not speed!

Rick

 

[Mike Lewis]

FoxWing,

If you run exactly the same query in VFP and MySQL, VFP will usually be faster (often much faster). However, you can get better performance with MySQL (or any other back-end server) if you adopt sound client-server design principles, such as aiming to do all your record selection on the server.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)