Osvaldo Ramirez <
ramirezosvaldo@yahoo.com> wrote in news:60632a59
$4fcce2c9$
a707@news.xbwin.com:
Please, if you have time, to post your comments about the meeting
The meeting was well attended and went very well. Steffen talked about
the future direction of Xbase++, including:
- Upcoming 1.9 service level 1
- Integration of SQL into core language
- Integration of PgSQL as the preferred Xbase++ client server solution
- Plans to tap into vast Visual FoxPro community
I gave a session on SQLExpress and Xb2.NET. Several performance
benchmarks were presented comparing DBF/Xbase style programming with SQL
style. Identical databases were used; one running on ADS v8, and the
second running MS SQLServer 2005. The following results:
NOTE: All queries running against equivalent data and return exactly the
same result (test program is attached).
1. Query :
Traditional DBF: 10.5 sec (running on ADS)
Brute force conversion of query to SQL: 13.5 sec (running on ADS)
Brute force conversion of query to SQL:4.2 sec (running on SQLServer)
Optimized SQL query: 5.0 sec (running on ADS)
Optimized SQL query: 0.05 sec (running on SQLServer)
2. Insert/Update:
Traditional DBF: 17.5 sec (running on ADS)
Optimized SQL: 2.4 sec (running on ADS)
Optimized SQL: 0.8 sec (running on SQLServer)
I also showed how to create a website from scratch using only Xbase++,
Xb2.NET and SQLExpress. The sample I used was the
http://xug.xb2.net site. This I thought was a good sample because it was simple (only a few
pages) and there was a data input (the registration page) and a data
output (the report showing who's registered).
After the meeting a few of us walked to a nearby pub where we sampled
some local beers and enjoyed each others company with more shop talk
including a discussion of the next step in human evolution... the
emergence of a super-intelligence (either artificial or biologically
enhanced). Here's some links about this topic:
http://mindstalk.net/vinge/vinge-sing.html http://en.wikipedia.org/wiki/Technological_singularity http://en.wikipedia.org/wiki/The_Singularity_Is_Near -- Best regards,
Boris Borzic
http://xb2.net http://sqlexpress.net industrial strength Xbase++ development tools