Very slow record retrieval through cursor
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 7 articles for 0.011 sec
Re: Very slow record-retrieval through cursor     

Group: comp.databases.berkeleydb · Group Profile · Search for Very slow record retrieval through cursor in comp.databases.berkeleydb
Author: Don Anderson
Date: Aug 31, 2007 20:31

...After a while, the cursor read process becomes very slow'. I guess that...DB_NEXT flag (sequence scan?) to the cursor and keep reading until finished. ... for your application, reading sequentially through an entire database? Because we are... that is leaking. Are all cursors closed when finished, and temporary .... Run these after the program slows down. The output can be ...
Show full article (12.73Kb) · Show article thread
Re: Very slow record-retrieval through cursor     

Group: comp.databases.berkeleydb · Group Profile · Search for Very slow record retrieval through cursor in comp.databases.berkeleydb
Author: Rabbit
Date: Aug 31, 2007 02:12

Very strange! I simply read through the data file (use std::ifstream) before I retieve data through cursor, it becomes very fast! Seems it depends on the file system's cache heavily!
Show full article (0.18Kb) · Show article thread
Re: Very slow record-retrieval through cursor     

Group: comp.databases.berkeleydb · Group Profile · Search for Very slow record retrieval through cursor in comp.databases.berkeleydb
Author: Rabbit
Date: Aug 30, 2007 19:12

... a while, the cursor read process becomes very slow'. I guess ... flag (sequence scan?) to the cursor and keep reading until finished.... that is leaking. Are all cursors closed when finished, and temporary ... clean the environment, it's very fast when read the first ... or 7 dbs, but becomes slow after that. Answers to any ...Run these after the program slows down. The output can be...
Show full article (9.08Kb) · Show article thread
Re: Very slow record-retrieval through cursor     

Group: comp.databases.berkeleydb · Group Profile · Search for Very slow record retrieval through cursor in comp.databases.berkeleydb
Author: Don Anderson
Date: Aug 30, 2007 11:58

... resource that is leaking. Are all cursors closed when finished, and temporary memory .... Run these after the program slows down. The output can be big...and almost the same acount of records (about 500,000). These dbs are...have 4 threads to retrieve data from them through cursor simultaneously but no two thread will operate...> read process becomes very slow, it need more than 20 seconds to...
Show full article (4.82Kb) · Show article thread
Very slow record-retrieval through cursor     

Group: comp.databases.berkeleydb · Group Profile · Search for Very slow record retrieval through cursor in comp.databases.berkeleydb
Author: Rabbit
Date: Aug 30, 2007 00:54

...8 bytes data) and almost the same acount of records (about 500,000). These dbs are opened in the... with transaction enabled. When initialization, I have 4 threads to retrieve data from them through cursor simultaneously but no two thread will operate on the same... 2 reads db 1, 5, ...; etc.). After a while, the cursor read process becomes very slow, it need more than 20 seconds to finish the read...
Show full article (2.90Kb)
Re: Very slow record-retrieval through cursor     

Group: comp.databases.berkeleydb · Group Profile · Search for Very slow record retrieval through cursor in comp.databases.berkeleydb
Author: Rabbit
Date: Sep 2, 2007 18:50

... here the guy is walking through a cursor, so I can predict ...> It is more like - the cursor visits all the data that is... for your application, reading sequentially through an entire database? Because we are...that matter to you. Reading sequentially through an entire database is not ... my own way), and provide very fast query service to the ... are good reasons it is slow - is the disk on a ...
Show full article (3.91Kb) · Show article thread
Re: Very slow record-retrieval through cursor     

Group: comp.databases.berkeleydb · Group Profile · Search for Very slow record retrieval through cursor in comp.databases.berkeleydb
Author: Rabbit
Date: Aug 30, 2007 19:50

Hi, I've got another better profiling result: 436,042,669,130 * ???:__dbc_get_pp [libdb-4.6.so] 3,340,463,958 ???:__dbt_userfree (128479383x) [libdb-4.6.so] 412,916,377,218 ???:__dbc_get (128479383x) [libdb-4.6.so] 1,430 ???:_dl_runtime_resolve (2x) [/lib/ld-2.3.6.so] 11,434,668,171 ???:__dbc_get_arg (128479383x) [libdb-4.6.so] 412,916,377,218 < ...
Show full article (16.99Kb) · Show article thread