ODBC - ASP.net Very Slow

Business Central/NAV Developers Forum
1

Hi, not sure if this post is still active. I am writing an ASP.net app that queries our Navision DB using ODBC. The queries are not very large and only hit one table at a time. I have a loop that perfoms a max of 20 queries, each returning approx 10 records. This query takes a full minute to execute! Seems rather long for a 200 (±) record query. Is this bad performance due to ODB. Is C/Front a better alternative?

Thanks,

Matt

2

Yes, C/Front is faster, but I would rather see if client moves to sql, and you could use SQL native drivers.

3

Thanks Rashed,

Converting to SQL Server isn’t an option at the moment, and unfortunately, we don’t have a license for c/front. Do you know of any other alternatives to ODBC? If not, are all custom apps using ODBC → NAV very slow? I can’t seem to find much info on this subject. Any ideas would be appreciated.

Thanks,

Matt

4

The c/front granule is not that expensive. Is there a reason you can’t add it to your license? You’ve probably spent more money chasing this problem already.

5

ODBC driver for native database never wasn’t very famous related to performance. C/front will use native database access. You will have a performance boost.