I have a project were i need to create a large amount of pages. Today I am planning on creating a custom table to hold the attributes. I also need to have real pages under categories(with page title, meta, etc). It will be 100,000 pages.

First I populate the custom table with the 100,000 items.
Then create the 100,000 inserts into [CMS_Tree]. I have a mapping table to put them in the right category.
Third, I insert into [CMS_Document] and and have a join back to CMS_Tree to get Nodeid, NodeCustomData and NodeAliasPath.

Nobody has seen an StoredProceedure or anything to make this easier correct?