I am also building a website completely based off K2 with over 500,000 items. Currently I have 3700 categories which I imported into the database and now I'm noticing K2 is running over 18000 SQL Queries as shown below. I turned on Catalog Mode and that cut the queries down to 8656, but obviously this is still highly atrocious. Does anyone have any tips on optimizing K2? I am a bit worried that Joomla/K2 might have been a poor CMS choice with such a gigantic project, but I am already far into the development process. Thanks.
SELECT * FROM jos_k2_categories WHERE id = '3974'
SELECT * FROM jos_k2_categories WHERE parent=3974 AND published=1 AND trash=0 AND access<=0 ORDER BY name ASC
SELECT * FROM jos_k2_categories WHERE parent=1 AND published=1 AND trash=0 AND access<=0 ORDER BY ordering
SELECT * FROM jos_k2_categories WHERE parent=2 AND published=1 AND trash=0 AND access<=0
SELECT * FROM jos_k2_categories WHERE parent=2 AND published=1 AND trash=0 AND access<=0 ORDER BY ordering
SELECT * FROM jos_k2_categories WHERE parent=4 AND published=1 AND trash=0 AND access<=0