Solved

Typical throughput of write access

Posted on 2016-09-02
3
12 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
  • 2
3 Comments
 
LVL 61

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 61

Expert Comment

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

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
A procedure for exporting installed hotfix details of remote computers using powershell
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now