setting up a database .. which is better??
Posted: Sun Jan 12, 2003 9:22 pm
Hello,
Forgot my user name, so this is a new one. I am FINALLY taking time to learn MySQL database.
As my first project, I am setting it up so I can keep track of affiliates and clicks and stuff. What I want to do is keep track of how many clicks, time, date, page clicked from, etc...
So in my first (successful) table, I have the info such as ID, title, url, image location, etc... I am wondering would it be better to have:
A) 1 table that has the information: time, date, page, affiliate ID in it and query by ID
OR
B) create a table for each affiliate link and keep track of that information.
I know I could queary either way, just which would be more efficient??
I have been doing flat file database programming for a while, and I have to say this MySQL thing looks so my easier and more efficient!!! I can't believe I have waited so long to get into it!
Forgot my user name, so this is a new one. I am FINALLY taking time to learn MySQL database.
As my first project, I am setting it up so I can keep track of affiliates and clicks and stuff. What I want to do is keep track of how many clicks, time, date, page clicked from, etc...
So in my first (successful) table, I have the info such as ID, title, url, image location, etc... I am wondering would it be better to have:
A) 1 table that has the information: time, date, page, affiliate ID in it and query by ID
OR
B) create a table for each affiliate link and keep track of that information.
I know I could queary either way, just which would be more efficient??
I have been doing flat file database programming for a while, and I have to say this MySQL thing looks so my easier and more efficient!!! I can't believe I have waited so long to get into it!