How to make index page with modules ?

[rosegarden]

I want to make my homepage static using xxx.html or xxx.php to reduce the sql queries but there are two tpl i want to include

#1 Recently Sold
#2 Newly added today

How can i add this two modules into the index page?

[Morgan Bohman]

Do a new welcome page with no blocks, then you can add whatever you like. In that way you get your header and footer in your site design.

[rosegarden]

I can get all the static content in the index page.

I am referring to the non-static content like the following in the block?

1) The latest listing? - listings_box.block.tpl - (show 4 listings)
2) The recently sold listing? - recently_sold.block.tpl - (show 4 listings)

[Mike]

Best way i think (for speed) is to implement function which will generate static content for these boxes and put somewhere to the server, configure cron job for this function and include static files.

But i honestly don't understand very well how you want to organize it, as any page in the flynax is working through index.php file and anyway there are some sql queries.