query optimization

[ki6i]

Is there someguide lines or article onquery optimization in Mega? Because sometimes there are pages which we currently implement with nesting which take about 50 min. to generate

[jhorber · Accepted solution]

Hello ki6i

I encourage you to read the documentation regarding queries in the manual MEGA Publisher (MEGA 2009 SP5)

http://community.mega.com/mega/attachments/mega/725/9/29/MEGA%20Publisher%20EN.pdf

This information is valid for higher versions.

You will find useful details

• Query examples
• Processing or NOT operator
• Operator INTO and KEEP

See also http://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=501D0000000KorHIAS

Note that with the operator KEEP, you can keep a query set for the session and test it.

Exemple

Run a first query to build a query set @AI and keep it in memory

Select [Application] Into @AI Where [Comment] Like "#incident#"
Keep @AI 

Then you can test this set without building this set again

Select [Application] From @AI Where [Application Type]="M"

[SVanSchoonlandt]

webpages?

I think leslie robinet wrote a blog article on optimization of scripts and query's.

http://community.mega.com/t5/Product-Blog/I-want-it-all-and-I-want-it-now-Performance-in-MEGA-delive...

I only found the above one, but I’m sure there is another post also on the query’s in scripts and using megafields.