>>Is it normal that to show this view it takes 5 seconds.
>
>It could well be normal even if fully optimized or partial with no deleted() tag (often no deleted tag is faster, and why Cetin recommended it). But SQL with that many tables and joins can be slow no matter what.
>
>The solution for this is to break up the SQL into 2 or 3 parts. Usually, with a little testing of different SQL split-ups, you can improve performance, sometimes very impressively.
Thanks, so you say that i most divide this SQL?
Luis
I never forget a face, but in your case I will make an exception :-)