Solved

Typical throughput of write access

Posted on 2016-09-02
3
23 Views
Last Modified: 2016-09-21
Hi, I am wondering what's the typical performance on throughput of Sybase database?

The one I am most interested is the write throughput. The entry should be very simple, one id being an integer, and value being some 500 byte serialized data

Is something around 5K - 20 K per second possible?
0
Comment
Question by:Tom Chen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 62

Accepted Solution

by:
gheist earned 250 total points (awarded by participants)
ID: 41782377
3600 rpm disk permits 3600 writes per minute. (at least 4k, typically max 32k...1MB)
Then add db log, filesystem journal etc, somehing like 30 per second on a old laptop.
Your 500 byte update should be batched in multi-row transactions at least.
SSD-s offer much more IOPs, still you should batch at least in 4K blocks as each write wears off the disk.
Sure you can blow away data integrity enable write caches and write 10x faster.
0
 

Assisted Solution

by:Tom Chen
Tom Chen earned 250 total points (awarded by participants)
ID: 41782413
3600 rpm then it's 60 per second. So if I batch for around 150~200 batch size should provide me the throughput right?

What do you mean by disk btw pls? Oh, to elaborate a bit, all the writes are creates, no update should take place here. Although periodically, some old logs should be deleted in batch as well
0
 
LVL 62

Expert Comment

by:gheist
ID: 41808392
DB and FS journaling took place
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
With the rising number of cyber attacks in recent years, keeping your personal data safe has become more important than ever. The tips outlined in this article will help you keep your identitfy safe.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question