Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 45
  • Last Modified:

Typical throughput of write access

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
Tom Chen
Asked:
Tom Chen
  • 2
2 Solutions
 
gheistCommented:
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
 
Tom ChenAuthor Commented:
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
 
gheistCommented:
DB and FS journaling took place
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now