This shouldn't have anything to do with the number of tables. It's more likely related to your indexes and/or the syntax of your queries. If you could post some brief sample code that gives an example of a query or other operation that results in poor performance someone might be able to help you.

>What is the optimal number of tables in a database. I have a database with around 175 entities and observe a poor performance in terms of data fetching.