MySQL Database Design - Questions on optimization
I am creating a database schema for a site we are currently working on. In the past, I have mainly used Access databases (I know, shame on me - they were easy!). I am now making the transition to MySQL, and attempint to tidy up my database creation practices in the meantime.
My first question:
I have a table for users setup as such
.....rest of physical info
....rest of site specific info
Would it be better to create two tables, one with physical info, that will not be displayed, one with site info, that likely will be used each time or would it be just as fast to simply create to recordsets, to fetch differing records from the same table, or will it make any difference at all?
My second question:
We are going to be creating the site using CSS. At the moment, the CSS is to be stored inside a database in records designated with "Scheme" numbers. Using this model, the page will be loaded, get the username and their Scheme number, then the scheme table will be accessed and it's values plugged into an inline style sheet.
My suggested model would be to store the schemes in a flat txt file (*.css) and simply pull in that file via an include. (ie, username is loaded, scheme is selected, css insert tags is written witht he location of the current style sheet (ie, Scheme4.css).
Does anybody have any thoughts on which one would be faster, or am I looking at 6 of one and a half dozen of the other?