4.7.x.x database options - sane values?

[C.S. 93]

"Database cache size" - is the limit 1024?

"Analysis row limit" - default is 400, but what would I put here if I wanted definite overkill, but still not complete insanity?

[kikinjo 281]

Think there is no limit, limit is your RAM on system. Increase gradually and see the performance, talking about cache size.
I m using 2048, with a lot of content, it is working really good.

[C.S. 93]

If you have a 2 GB db, then you are my hero.

[kikinjo 281]

It is easy to be a hero for you

[LindsayCole 0]

As someone with a 1.9GB database, I would love to know the ideal settings for this.

I've got my row limit set to 1250, and my cache size to 4096MB. I did see a performance improvement with these settings.

Would like to know if I could benefit from going higher on either value?

[adrianwi 279]

Should I be worrying that my database is 125.73GB 

I've got a cache size of 1024 and 750 row limit and performance is pretty good.  Application and database both running from SSDs, with media on HDD NAS.

[Luke 42077]

4 minutes ago, adrianwi said:

Should I be worrying that my database is 125.73GB 

I've got a cache size of 1024 and 750 row limit and performance is pretty good.  Application and database both running from SSDs, with media on HDD NAS.

That's pretty large. You could probably crunch it down a bit by vacuuming.

[Luke 42077]

12 minutes ago, LindsayCole said:

As someone with a 1.9GB database, I would love to know the ideal settings for this.

I've got my row limit set to 1250, and my cache size to 4096MB. I did see a performance improvement with these settings.

Would like to know if I could benefit from going higher on either value?

You can set them as high as you're willing to go when taking into account the costs or tradeoffs that are mentioned in the help text underneath each option.

[Seger 123]

My database is >200gb off the top of my head, interesting discussion. My database is also on an SSD. Is the RAM always faster? Have 16gb of which only 8gb is needed for my server. I can also play around. But will it only be perceived speed or is there a way to measure it?

[Luke 42077]

2 minutes ago, Seger said:

My database is >200gb off the top of my head, interesting discussion. My database is also on an SSD. Is the RAM always faster? Have 16gb of which only 8gb is needed for my server. I can also play around. But will it only be perceived speed or is there a way to measure it?

I don't think I would trust putting the database on a ramdisk.

[LindsayCole 0]

19 minutes ago, Seger said:

My database is >200gb off the top of my head, interesting discussion. My database is also on an SSD. Is the RAM always faster? Have 16gb of which only 8gb is needed for my server. I can also play around. But will it only be perceived speed or is there a way to measure it?

At the risk of going off topic here a bit; how is your database that large? How large of a library do you have?