In one of the Baan document a particular info on level2 driver for SQL Server goes like this....
...the performance of Level2 driver on average is equivalent to the performance of the SQL Server level 1 driver.

If so, will there be any noticeable improvement in converting to a Level2 driver from level1?

Has anyone worked on level1 in Baan4/SqlServer and then converted to level2 and seen any major improvement or performance gain?

sk

Hi Sukesh,

I have worked on Level 1 and Level 2. And I can say that the sentence which explored is correct in general.

Only thing, if you are on Level 1 and would like to integrate other softwares (May be VB based) with your BaaN database, then its not possible. As BaaN uses its own algorithm to update the index in table.

regards,

-Suhas

When you say VB based software, are you referring to AFS indirectly? As Afs lies between Baan and VB...

sk

No...AFS is a proper way to perform updates in BaaNs tables.

I was just pointing that ex. if you have VB based HR application wherein you would like to update salaries in BaaN finance, it is not possible.

Hope this helps.

regards,

-Suhas

I have worked with L1 and L2 and there is a hughe performance improvement, also database size reduces up to 30-40% of your old L1 DB size.

Reports that used to take minutes and or hours now take a few seconds to run

As Suhas explained it gives you alternative to integrate other applications with Baan at the DB level

Thanks Daniel. So there is a noticeable change in performance. Could you also let me know how many users you have and whats the size of your database(before adopting L2)...

sk