Hi what you guys recommend me
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.
right now im using postgresql
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
Sounds good. Basically i got one query to list clients
- Query to get jobs from those client
- To get personal reference
- Any discounts they have as its a loan company
They are all diff tables
So you say i can combine that in a view in postgresql? Like many Joins in one query?
Yes, this can be done so long as you have a key(clientID) in each table that you can JOIN on....