Solved

Typical throughput of write access

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sybase - How to edit cron schedule for sybase backups 3 900
SQL Time Syntax 4 311
the error when installation Sybase ASE 15.7 x64 bon Windows 37 3,064
sybase output only middle rows 4 43
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
No single Antivirus application (despite claims by manufacturers) will catch or protect you from all Virus / Malware or Spyware threats. That doesn't stop you from further protecting yourself however - and this article is to show you how.

685 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