Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Berkely DB > Improving whole...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 1716 of 1804
Post > Topic >>

Improving whole-database scan performance

by Florian Weimer <fw@[EMAIL PROTECTED] > Feb 14, 2007 at 10:24 AM

Is it possible to traverse a B-tree database (possibly in non-index
order, with read-comiitted isolation) in a way such that most accesses
happen in on-disk order?  Due to internal fragmentation,
whole-database scans are annoyingly slow once the database size
exceeds available RAM.

Would be using DB_RECNO or a sequence-based key a suitable workaround?
 




 4 Posts in Topic:
Improving whole-database scan performance
Florian Weimer <fw@[EM  2007-02-14 10:24:08 
Re: Improving whole-database scan performance
Florian Weimer <fw@[EM  2007-02-14 19:05:03 
Re: Improving whole-database scan performance
"Klaas" <mik  2007-02-14 17:55:40 
Re: Improving whole-database scan performance
Florian Weimer <fw@[EM  2007-02-15 10:42:19 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 0:30:48 CDT 2008.