This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How big DB file can be

 
Ales Moukhine
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ranchers,

I'm almost close my DB module, now doing some tests.
Size of example DB file - 6k.
And dbEngine can serve 600-800 find/read/delete/create/update operations per sec.
with 10 concurrently users. (Pentium M 1.7Gh).

First question is it enough?

Next I notice that with 2M DB file, 10 concurrently users can do only 10-15 operation per sec.

I know where is the problem, but I decided to not implement cache functionality.

What do you think is it important for those who will mark assignment?

Regards
Ales'
 
Daniel Bryant
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ales,

If you look back at your project requirements document from Sun it states that a functional clear design is preferred over a complex high-performace design, and so I think provided your DB is safe for concurrent use and well coded you will have no problems.

Besides, you could recommend in your choices.txt that Sun swap your current DB implementation for a commercial RDBMS if they are looking for performance...

Daniel
 
Ales Moukhine
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Daniel,

I hope I know how "well coded" look like

In instruction I have "A clear design, such as will be readily understood by junior programmers, will be preferred to a complex one, even if the complex one is a little more efficient. Code complexity, including nesting depth, argument passing, and the number of classes and interfaces, should be reasonable. "

But providing caching will be "more more more efficient" not "little more efficient".

But thank you for reply

Regards
Ales
 
Daniel Bryant
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I hope I know how "well coded" look like
I hope I do too...

You make a good point about a cache being much more efficient - I think as long as you justify your reasons for implementing a cache in your choice.txt you should be fine (I've read posts on the ranch where people have passed with and without caches, and so it doesn't appear to be a showstopper)

However, what concerns me is that implementing a cache does involve more code, which could be making the solution more complex and also potentially introduce more errors connected with concurrent access etc. This IMO, means I won't be implementing a cache, but it would be interesting to hear other views...

Daniel
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic