Results 1 to 2 of 2

Thread: Extremly slow random access

  1. #1
    Junior Member
    Join Date
    Oct 2015
    Posts
    5

    Default Extremly slow random access

    Hi,

    After modifications of the project "STSdb4.SpeedDemo" to include random reads, the result is simple : STSdb is extremely slow compared to engine like LevelDB. I haven't found why it was so slow. On random inserting, STSdb is a lot faster than anything. On random read, it's the slowest engine I've never seen.

    Is there a reason ?

    Thank you.
    Last edited by Gabbby; 28.10.2015 at 20:21.

  2. #2

    Default

    Greetings.

    The STSdb 4.0 indexing structure (WaterfallTree) is heavily optimized for large bulk inserts of random and sequential keys. (The sequential read is also fast.)

    I would sugest you to read the following posts which describe the problem of random reads and offer different approaches for solving it:

    Post #2: Slow read performance and other evaluating questions
    Post #4: Slow query response on graph like queries

    In general, the random read speed can be increased, but there is a price to pay for the increased insert performance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
2002 - 2014 STS Soft SC. All Rights reserved.
STSdb, Waterfall Tree and WTree are registered trademarks of STS Soft SC.