# Configuration recommendations

**URL:** https://forum.yugabyte.com/t/configuration-recommendations/2636
**Category:** General
**Created:** [May 14, 2024, 2:30pm UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636 "2024-05-14T14:30:12Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![olivan139](https://avatars.discourse-cdn.com/v4/letter/o/ed8c4c/32.png) [@olivan139](https://forum.yugabyte.com/u/olivan139)
#### Post date: [May 14, 2024, 2:30pm UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636/1 "2024-05-14T14:30:12Z")

</div>

The question is: which configuration is the best for achieving 100-200k requests per sec? What might be tuned to improve overall performance?

Also I’m interested in how ulimits works, is it an analogue of resource groups?

---

<div class="post-metadata">

### Author: ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)
#### Post date: [May 14, 2024, 2:47pm UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636/2 "2024-05-14T14:47:38Z")

</div>

Hi @olivan139

Please see [Best practices for YSQL applications | YugabyteDB Docs](https://docs.yugabyte.com/preview/develop/best-practices-ysql/) & [Deployment checklist for YugabyteDB clusters | YugabyteDB Docs](https://docs.yugabyte.com/preview/deploy/checklist/#hardware-requirements) for general info. After those it will depend on the workload.

> [@olivan139](#):
>
> Also I’m interested in how ulimits works, is it an analogue of resource groups?

Please see [What is ulimit in Linux? - Scaler Topics](https://www.scaler.com/topics/what-is-ulimit-in-linux/)

---

<div class="post-metadata">

### Author: ![olivan139](https://avatars.discourse-cdn.com/v4/letter/o/ed8c4c/32.png) [@olivan139](https://forum.yugabyte.com/u/olivan139)
#### Post date: [May 15, 2024, 8:31am UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636/3 "2024-05-15T08:31:01Z")

</div>

> [@olivan139](#):
>
> The question is: which configuration is the best for achieving 100-200k requests per sec? What might be tuned to improve overall performance?
> 
> Also I’m interested in how ulimits works, is it an analogue of resource groups?

Thanks a lot for sharing info about ulimit!!!

I have already read general info about deployment and unfortunately haven’t found anything I need. I asked this question because I thought that someone has already faced similar conditions and found the best way to achieve “maximum”

---

<div class="post-metadata">

### Author: ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)
#### Post date: [May 15, 2024, 12:00pm UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636/4 "2024-05-15T12:00:17Z")

</div>

> [@olivan139](#):
>
> I asked this question because I thought that someone has already faced similar conditions and found the best way to achieve “maximum”

The way to achieve maximum utilization is to use the database efficiently by following the best practices.

You can use [GitHub - yugabyte/yb-sample-apps: Workload generator for emulating various real-world scenarios against YugabyteDB](https://github.com/yugabyte/yb-sample-apps/) or [Benchmark YSQL performance using TPC-C | YugabyteDB Docs](https://docs.yugabyte.com/preview/benchmark/tpcc-ysql/) as apps that follow best practices on the client side to benchmark the db.

---

<div class="post-metadata">

### Author: ![olivan139](https://avatars.discourse-cdn.com/v4/letter/o/ed8c4c/32.png) [@olivan139](https://forum.yugabyte.com/u/olivan139)
#### Post date: [May 16, 2024, 10:15am UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636/5 "2024-05-16T10:15:57Z")

</div>

Got it, thank you!

I also have a question about ycql and ysql. I have just found out that data and tables created with ycql are not accessible via ysql. Should I create another post with this question?

The question is: Is there any possibility to access common data and tables with ycql and ysql?

---

<div class="post-metadata">

### Author: ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)
#### Post date: [May 16, 2024, 10:52am UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636/6 "2024-05-16T10:52:26Z")

</div>

> [@olivan139](#):
>
> The question is: Is there any possibility to access common data and tables with ycql and ysql?

No, it’s not possible.

---

<div class="post-metadata">

### Author: ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)
#### Post date: [May 16, 2024, 10:56am UTC](https://forum.yugabyte.com/t/configuration-recommendations/2636/7 "2024-05-16T10:56:01Z")

</div>

See [FAQs about YugabyteDB API compatibility | YugabyteDB Docs](https://docs.yugabyte.com/preview/faq/compatibility/#can-i-insert-data-using-ycql-but-read-using-ysql-or-vice-versa) for more info.
