Hello,
I was wondering it there was a way to optimize a view.
If my view contains 20 LEFT joins, my guessing is that each time I will
make a select on it, the view will be completely recalculated. Is there
a way to have it up and running all the time like a table would be ?
Any advice here is
Alban Hertroys wrote:
Richard Ollier wrote:
Hello,
For a project I have a table containing products and flags.
The columns of this table are of 2 kinds :
- Not null data (id, column1, column2)
- Flags (100 different flags set to 1 or 0)
Over the time the number of flag will increase from 100
Hello,
For a project I have a table containing products and flags.
The columns of this table are of 2 kinds :
- Not null data (id, column1, column2)
- Flags (100 different flags set to 1 or 0)
Over the time the number of flag will increase from 100 to 200 or more.
So I have 2 choices :
- Use a
