dbTalk Databases Forums  

High latency on writes

comp.databases.berkeley-db comp.databases.berkeley-db


Discuss High latency on writes in the comp.databases.berkeley-db forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Phantom
 
Posts: n/a

Default High latency on writes - 02-21-2006 , 01:13 PM






Hi All

For some reason I get a very high latency on a database writes, more
than a second and a half to write into two databases. I am very new to
BDB and I am wondering as to what I need to do to tune Sleepycat to
make this better.

At this point we have checkpointing occuring every 1 minute and the
trickle write feature set to 90%. We do not sync to disk on every
write. The two databases in question have their page sizes set to 512
and 4096 bytes. Is there any other information that I need to provide
you guys with for pointing me in the right direction ?

What do I need to do to reduce these latencies ?

Thanks
A


Reply With Quote
  #2  
Old   
Ron
 
Posts: n/a

Default Re: High latency on writes - 02-21-2006 , 02:33 PM






Hi,

You haven't provide much information here to help.

How large are your 2 databases?
What type are the?

At what point do you notice that latency?

What do your keys look like in each database? Are you entering the
records in sorted order by key?

Please post (assuming it is small) your application here so we can talk
a look at it.

Size of your cache?

How obten do you call sync?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.