I found out mojoportal, and I could not believe how awesome this product is. I am a sql server DBA/architect can also code in C# but nothing web related. Thanks to mojoportal I started building my personal consulting portal/blog etc. What I did is digged into the database structure little bit and created pages mimicking microsoft sql server management studio object explorer style interface with the code I have written and keeping as a library in the last years. I build the page indexed everything perfectly (the index is slightly over 300MB if that gives you an idea). I added some additional columns to mp_pages, mp_htmlcontent, mp_modules, mp_pagemodules etc table to keep track of what changed in the last week in my library (since I get a current snapshot of all my objects and full overwrite the existing data in mojoportal I know exactly which pages have changed). Now I would like to only rebuild the indexes on the newly added (less than 1% of the data usually) records (i know in mp_pages, mp_htmlcontent, mp_modules, mp_pagemodules are new).

I noticed there is a table mp_IndexingQueue but not sure how it is used etc. You can feel free to browse the site www.sqlboost.com if anything interests you. (probably it's better if you directly go to http://www.sqlboost.com/Util_dbo_BinaryReverse.aspx since the contents are not under the main page).

Anyway can I control the indexing of the newly added pages not using the interface but directly from the database?

Thank you

Question still remains how do I force page contents to be indexed again without deleting all the files in the index directory and have my home desktop crank the harddrive for couple hours?

Can I insert some records into a table with the page id's or module id's so that they will be picked up.

About inserting data not from user interface, there was no other way of doing it, there are over 8000 pages I am generating once an hour at work hours and comparing of changes and keeping the site up to date with changes. Can't be done with a ui. I gotta figure out how to have the index be accurate after the changes to make sure it picks up the new pages etc.

... and yes probably only 15% of my content is actually can be seen by non administrators or users I assigned right to, therefore bing or google search probably will not do too good for me.

Thank you