i got a lot of queries, they are all diff tables but linked by one primary Key, = clientID, my question will be, you recommend me leave the app like that or maybe create one big query with multiple joins to get almost all info in one query? that will be more than 100 columns.
It really depends on when you need the data in each of the queries... you could also create a VIEW in the db and select on that when you need instead of running all queries separately... tough to say because I don't know your app well enough