Q: slow data adaptor

9 Mar 2005 3:57 PM

Geoff Jones

Hi

I am loading a DataSet using a DataAdaptor e.g.

myDataAdaptor = New OleDb.OleDbDataAdaptor("Select * From [myTable]",
myConnection)

myDataAdaptor.Fill(myDataSet, "MyTable")

The table is very large and it takes quite a few seconds for these two steps
to complete. I do not need to write back to the table and I was wondering if
using a DataAdaptor may be a bit of overkill. I do need a DataSet to perform
some quite complicated data analysis.

I believe that a DataReader may be a way of speeding things up but I don't
have any idea of how to do the above using it. I'm sure this is a very
simple question so please forgive my ignorance - you may have gathered that
I'm new to all this database stuff!

Thanks in advance

Geoff

9 Apr 2005 7:50 PM

Chef Groovy

I had to upgrade my Access database to SQL2000 after it got soo big. The
lookups just got too slow for production. Seems access was slow even
with 100k records or so. MSSQL is almost instant. Money well spent.

And the beauty was that converting code to work with sql was pretty much
just changing the connection string, everything else just fell into
place.

Show quoteHide quote

"Geoff Jones" <nodamnspam@email.com> wrote in
news:422f1cda$0$26725$cc9e4d1f@news.dial.pipex.com:

> Hi
>
> I am loading a DataSet using a DataAdaptor e.g.
>
> myDataAdaptor = New OleDb.OleDbDataAdaptor("Select * From [myTable]",
> myConnection)
>
> myDataAdaptor.Fill(myDataSet, "MyTable")
>
> The table is very large and it takes quite a few seconds for these two
> steps to complete. I do not need to write back to the table and I was
> wondering if using a DataAdaptor may be a bit of overkill. I do need a
> DataSet to perform some quite complicated data analysis.
>
> I believe that a DataReader may be a way of speeding things up but I
> don't have any idea of how to do the above using it. I'm sure this is
> a very simple question so please forgive my ignorance - you may have
> gathered that I'm new to all this database stuff!
>
> Thanks in advance
>
> Geoff
>
>
>

--
---------
Der Chef Groovy
ICQ: 1529949