Servoy vs. VFP 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 spear points.
How does Servoy compare to Visual FoxPro in terms of speed when handling data in different scenarios 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 many equal starting conditions as possible.
What's in the benchmark:
1.
- Primary key search - Smart Client
- Primary key search - Web Client
2.
- Lastname index search - Smart Client - without string matching options
- Lastname index search - Web Client - without string matching options
3.
- Streetname index search - Smart Client - with string matching options
- Streetname index search - Web Client - with string matching options
4.
- Zipcode search - Smart Client - no index
- Native database search - Benchmarks
- Conclusions
- Demo form - 20 million records
You have to keep in mind that measuring performance is tricky business. There are many factors that influence the measurements. But overall the trends are obvious and the conclusions are accurate.
VisualFoxpro.com © 2010-2024 • All rights reserved • Servoy B.V.