Which Is The Fastest Ole Db Provider ?

[madsovenielsen]

Hello all.Im currently involved in some Classic ASP development for a Yellow Pages like service in Denmark. We are using an Oracle database with the Microsoft OLE DB Provider. Speed is really important, we have 7.000.000 records in the database. Is the Oracle OLE DB provider faster ?/mads

[justsomeguy]

I would tend to favor something from the vendor over a third party, but one thing that's clear is that compiled ASP.NET will be significantly faster than Classic ASP.

[madsovenielsen]

I would tend to favor something from the vendor over a third party, but one thing that's clear is that compiled ASP.NET will be significantly faster than Classic ASP.

Yes. But none in the company knows ASP.NET so they are not willing to switch.I found an article, Oracle OLE DB Provider vs. MS OLE DB Provider. so that cleared things up.Thanks

[justsomeguy]

But none in the company knows ASP.NET so they are not willing to switch.

That's unfortunate, if speed is really that important you would think they would not want to use an unsupported technology from 1997 as the foundation. Programmers unwilling to learn new technologies find themselves out of work.