cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

query optimization

Solved
Highlighted
Contributor

query optimization

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

Tags (2)
2 Replies
Regular Contributor

Re: query optimization

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.

MEGA

Re: query optimization

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"

 

 

 

 

 

 

Jerome