Hello, I am planning to code a site where will be similar to affiliate marketing website. For that I need to keep track of all their sales, I expect that my site will have 10,000 affiliates and over 500 different web products.
So, for that i wanted to know how to design a MYSQL Schema by which we can keep a record of all their sales organized with date, amount, commission, number of units sold, sold to whom etc..
How to do that?
Thanks in advance.
MYSQL Schema - Help
Moderator: General Moderators
Re: MYSQL Schema - Help
If you're running a website with a lot of traffic and a lot of entries and queries, you'll need to make sure your MySQL installation has been optimized. Pay special attention to the design of your databases. I found a decent presentation explaining good database design for optimal performance and efficiency.
It's tough at first when you're coming up with a design but over time it'll come with ease. Pay attention to the application's needs, your audience, and other key factors. Knowing what data needs to be stored and how it must be retrieved will help a lot.
It's tough at first when you're coming up with a design but over time it'll come with ease. Pay attention to the application's needs, your audience, and other key factors. Knowing what data needs to be stored and how it must be retrieved will help a lot.