Mssql Structure

[RFH Reseller: creativeworks]

I'm giving myself a project, and I wanted to build a multi user site. it allows users to build their own mini sites using a CMS backend...

i'm going to be using .net with mssql.

my problem <dramatic tension building music> dun dun dunNNNnnnn....
i've only ever built single site CMS databases.



building something this big with so much growth potential has me wondering about db capacity, and table capacities... total number of records in a single table etc etc... total number of tables...

i realise this is a totally open ended question with many ?whatif! and i could google for most answers - any ideas where i should look first before i start designing and building my db? or better still, any suggestions!!!!

while i'm asking questions, any ideas on the BEST .net HTML WYSIWYG editor for CMS systems... willing to spend upto about 80 squid maybe? for a single domain licence....

RAH!

[Spire]

Hi

Well as far as I know u will have almost unlimited room for growth, as I understanted it you can store many Terrabytes of data in MSSQL server databases if it is designed correctly.

I use this http://www.fckeditor.net/ WYSIWYG editor it has a plug in for .net and has a version that will produce XHTML and best of all it's open source