Fastest way to read data from MySQL using C#

Question

I'm wondering if there is a faster method than using something like:

while (Reader.Read())

to read the results of mysql select queries.

I'm randomly pulling 10,000 rows from a database and would like to read it as quickly as possible. Is there a way to serialize the results if we know what they are (such as using the metadata to setup a structure)?

Przemysław Michalski · Accepted Answer · 2011-01-11 20:24:20Z

5

Try MySQLDataAdapter.Fill method to fill any DataTable object - read speed is comparable to optimal usage of read data with Read method (depends on your while block reading way) and main advantage is that you achieve prepared data collection which you can manage or just write to XML file.

edited Jan 11, 2011 at 20:24

answered Jan 11, 2011 at 20:18

Przemysław Michalski

9,9177 gold badges34 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fastest way to read data from MySQL using C#

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related