We are currently running Clarion 10 using Legacy templates with SQL Server as our database backend.
We are currently testing Clarion 12 (build 14000) and evaluating whether it’s time to fully migrate our production apps.
For those who have already made this move:
Did you notice any measurable or real-world performance improvements when transitioning your EXE to Clarion 12, specifically regarding SQL Server communication and query execution?
Since we are on Legacy, were there any specific caveats, breaking changes, or tweaks required during the migration?
Any insights, benchmarks, or experiences with C12 build 14000 would be greatly appreciated!
I dont think you will see much in the way of performance gains between c10 and c12 with respect to the MSSQL driver. While there were some improvements to the driver in C11, and C12 they weren’t really focused on performance.
That said, there are ways (even in C10) to improve performance accessing the database. Even the old drivers contained many possibilities for improving performance based on what specific task you were trying to do.
If you are currently experiencing places where performance is sub-optimal then there’s perhaps a larger conversation to be had for each circumstance that you are encountering.
Plus of course you can switch to the new MSSQL2 driver (CapeSoft File Driver Kit) which then opens the door to many other possibilities- and which is a bit more “legacy friendly”. But the new driver is not cheap, its more of an option for serious programs.
When compiling with C12, I can’t open the FORM files; I get an error:
“Connection already in use by another S1000 command.”
But if I switch to the clamss.dll from C11,
it works fine. Will you be able to fix this?
I can’t change the shipping drivers. So no, i cant fix that bug. Your solution thogh is a good one.
That bug is not in the MSSQL2 driver. The new drivers are all new code. Written in Clarion not C. And shipped as source so bugs can be fixed, if necessary, by the community.