Yes this is vague because I'm more used to editing aside from designing databases.
I'm working on a database (new) where right now it's not going to be used for much aside collecting basic client data ie~
$aa->whatever-name(
'table_name',
'column1, column2, column3, column4, column5, column6, column7',
':Name, :Email, :Subject, :Phone, :PhoneExtension, :Website, :Message',
array(
'Name' => $Name,
'Email' => $Email,
'Subject' => $Subject,
'Phone' => $Phone,
'PhoneExtension' => $PhoneExtension,
'Website' => $Website,
'Message' => $Message
)
);
Later I plan to insert this data into a form , then insert the form into a customers account, as well as add column(s) for other obvious client information.
My question is knowing this later will be heavily used, would I be better off creating a new table for each user / client than this way. I'm talking performance reasons.
I've got one chance to get this right , as I say right now this will only collect new clients as they submit a form for a quote, later I will have to create a script to manually add thousands of clients and their current as well as past customer information. Daunting task ahead , so I must get this at least close to as simple as possible.
I'm aware this is a basic sql question , but I don't think it will be for long.