communication is very slow

[saurabhsondhi]

We are having a application in which VB 6.0 communicates with SQL Server 2000 ....

This communication is very slow and becoming the bottle neck in the system ...

If we move from VB 6.0 to VB.Net and SQL 2000 to SQL 2005 , would there be any performance gain , if yes how much gain we can expect...

We need to evaulate the gain before writing the code base in VB.Net

Thanks in Advance

Regards

Saurabh Sondhi

 

[wakh]

You would for sure achieve a gain after switching because you will be using codebase that has been written and optimised specifically for SQL Server 2005+ instead of older technology (ODBC) which works with all the databases but got a performance penalty. How much gain you'll get is something that cannot be said. It depends on the application, and you need to test it out yourself.

 

[cjard]

We are having a application in which VB 6.0 communicates with SQL Server 2000 ....

This communication is very slow and becoming the bottle neck in the system ...

Why? What takes so long? Hundreds of apps were written in VB6 and SQLS2000 many years ago and they were very fast. They should still be.. It's not like a programming language gets slower as it gets older.

If we move from VB 6.0 to VB.Net and SQL 2000 to SQL 2005 , would there be any performance gain , if yes how much gain we can expect...

Likely: No

We need to evaulate the gain before writing the code base in VB.Net

You need to fix the problem that exists now, because making all the same coding mistakes in your new app is not going to make anything faster.