Contents:

 

 

Introduction


News blog


What is Servoy?


Getting Started


Comparison Servoy/VFP


Performance


How-To's

 

Code Reference

 

VFP2Servoy Toolkit

 

 

Contact / feedback

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Servoy Data Performance Comparison



For Servoy World 2011 I did a presentation on Data Performance in Servoy. Speed has always been one of VFP's major spearpoints. How does Servoy compare to Visual FoxPro in terms of speed when handling data in different scenario's and with different databases?

I did extensive tests using Servoy 5 Smart Client and Web Client with Visual FoxPro data (old and new driver), PostgreSQL and SQL Server with several types of indexes and without indexes. I also tried doing consecutive tests, averaging the results because consecutive lookups are handled faster for most databases. For the start of each test I rebooted to create as much equal starting conditions as possible.

You can find the following test result below:

  • Primary key search - Smart Client
  • Primary key search - Web Client

  • Lastname index search - Smart Client - without string matching options
  • Lastname index search - Web Client - without string matching options

  • Streetname index search - Smart Client - with string matching options
  • Streetname index search - Web Client - with string matching options

  • Zipcode search - Smart Client - no index

  • Native database search - Benchmarks

  • Conclusions

  • Demo form - 20 million records


  • Of course you have to keep in mind that measuring performance is tricky business. There are many factors that influence the measurements. But overall I think the trends are obvious and believe that the conclusions are accurate.
















    External resources:

     

    vfp plugin

     

    ServoyWorld 2012 pics

     

    Official Servoy website

     

    Ken Levy on Servoy

     

    Servoy info

     

    Servoy Forum

     

    Servoy Documentation

     

    VisualFoxpro.com © 2010-2012 • All rights reserved • Contact: info@visualfoxpro.com