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!
setting up a database .. which is better??
Moderator: General Moderators
- mydimension
- Moderator
- Posts: 531
- Joined: Tue Apr 23, 2002 6:00 pm
- Location: Lowell, MA USA
- Contact:
- mydimension
- Moderator
- Posts: 531
- Joined: Tue Apr 23, 2002 6:00 pm
- Location: Lowell, MA USA
- Contact:
nope, size isn't a realistic problem. DB servers are designed to handle insanely large tables so that you don't have to
. but if you still want to worry about size you might think about prunning options similar to what the phpBB (eg. this forum) system does, which is to delete old entries every once and in a while.
-
fractalvibes
- Forum Contributor
- Posts: 335
- Joined: Thu Sep 26, 2002 6:14 pm
- Location: Waco, Texas