Should I use DataSets?

kduke · Post by **kduke** » Tue Jun 29, 2010 11:15 am

Still 4,000 rows per second is very slow.

dougcl · Post by **dougcl** » Tue Jun 29, 2010 11:30 am

chulett wrote:You marked your post as using the UNIX system for your server, hence the confusion. ...

Actually I marked my post as using the UNIX system for our server, because we are. Raftsman is just here stirring up trouble

dougcl · Post by **dougcl** » Tue Jun 29, 2010 6:01 pm

Raftsman wrote: When I read, I get approx 4000 row/sec. from a dataset. When I read from Oracle, I get 30000 rows/sec.

Hi just ran some tests here. I have a table with 180 byte rows. Reading 10M rows into dev/null from Oracle runs at 50K rows/sec. Reading 10M rows from a dataset into dev/null runs at 170K rows per second.

Please note we are storing datasets on a SAN.

I haven't done much write testing to Oracle yet, but our write performance to the dataset easily keeps up with the Oracle reads.

Thanks,
Doug

chulett · Post by **chulett** » Wed Jun 30, 2010 6:17 am

dougcl wrote:
chulett wrote:You marked your post as using the UNIX system for your server, hence the confusion. ...
Actually I marked my post as using the UNIX system for our server, because we are. Raftsman is just here stirring up trouble

Sorry, failed to recognize the hijack!

Raftsman · Post by **Raftsman** » Wed Jun 30, 2010 7:52 am

I didn't hijack, I was giving my two cents regarding performance. I realize they are two different operating systems but the subject is the same. As for stirring up trouble, no. I would prefer to use datasets.

So in summary, I wasn't hijacking the thread. I would figure that Windows and Unix would have some similarities.

chulett · Post by **chulett** » Wed Jun 30, 2010 8:22 am

OK, wrong word then. Double-sorry.