I noticed that the db that the Club site starter kit does not contain the tables to store roles, users ets...

Should a new database be created or should these tables be created in the same database?

Whats your opinion

ASP.NET will automatically create aspnetdb.mdf for those when you run the site.

You can run aspnet_regsql to create the tables in a SQL 2000 / SQL 2005 database then modify the connection strings to use this.

Thanks

I had allready gotten it to work. I was just worndering which would be the correct way from a design perspective to do it.

It depends on your contraints.  We optimized for file download size.  By having the database autogenerate, we didn't have to ship an extra db as part of the package.

If you are paying per database fees to your hoster, then combining the two databases into one could save you some money.

From a performance standpoint, merging into one database would be more performant and run a slightly smaller memory footprint.  However, you probably wouldn't notice the difference unless you were running thousands of these sites.

As a footnote, this kit isn't meant to be a beacon of performance.  We did not excersize certain advanced features and optimizations to make the code easier to understand to a wider audience.

Hope this helps!

Thank you that was just the type of information that I was looking for.