Solved

Typical throughput of write access

Posted on 2016-09-02
3
19 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

We asked our MSP customer base what their favorite tools were and how they help them serve clients. We focused our questions on favorite tools in the following categories: >PSA tools >RMM tools >Alert management tools >Communication tools and Mo…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

710 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