Page 2 of 2
Posted: Tue Jun 29, 2010 11:15 am
by kduke
Still 4,000 rows per second is very slow.
Posted: Tue Jun 29, 2010 11:30 am
by dougcl
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
![Smile :)](./images/smilies/icon_smile.gif)
Posted: Tue Jun 29, 2010 6:01 pm
by dougcl
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
Posted: Wed Jun 30, 2010 6:17 am
by chulett
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
![Smile :)](./images/smilies/icon_smile.gif)
Sorry, failed to recognize the hijack!
![Mad :x](./images/smilies/icon_mad.gif)
Posted: Wed Jun 30, 2010 7:52 am
by Raftsman
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.
Posted: Wed Jun 30, 2010 8:22 am
by chulett
OK, wrong word then. Double-sorry.
![Wink :wink:](./images/smilies/icon_wink.gif)