Multiple Sites with single databse,single code base

Question

0.00/5 (No votes)

See more:

Hi Friends,

I need your great help in developing a new Asp.net project.

I have 3 websites Site1,Site2,Site3 running on their own Code base's & Databse's.

All are Job portals having 3 roles i.e Admin,Employer,Job seeker.

Now my requirement is to have a Single code base,Single Databse for all the sites.

Means all the content and state specific date should come dynamically according to the URL requested.

What is the best way to achive this and if I maintain same database then how to change the existing schema .

If I have Single database will the performance goes down.

Please suggest me the best approach .

Thanks in advance.

Posted 30-Nov-10 18:53pm

sandeep sangshetty

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nagy ramadan · Answer 1 · 2010-11-30T19:14:00

Solution 1

I working in some thing like this
and this is my method:
you can give for example id for each site and if these three sites for
example in different server you can set the id of the site on the web config
and when you requested for example the url of site 1 load your data from db according to the siteid in the config file

you will make the site id is the filteration method when requesting any url
for exampl http://me.com/viewpage.aspx?siteid=1

Posted 30-Nov-10 19:14pm

nagy ramadan

Comments

sandeep sangshetty 1-Dec-10 1:38am

Thanks for ur reply.

I want to have the siteIds in sepreate table for the future sites.
So in order to refer the state specific data i need to add the new column 'SiteId' in each and every table ,But while retrieving it may take lot of time.
This may degrades the performance of the site.