MYSQL Schema - Help

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
anand
Forum Commoner
Posts: 80
Joined: Fri May 22, 2009 11:07 am
Location: India
Contact:

MYSQL Schema - Help

Post by anand »

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.
User avatar
Gabriel
Forum Commoner
Posts: 41
Joined: Wed May 06, 2009 8:12 pm
Location: Las Vegas

Re: MYSQL Schema - Help

Post by Gabriel »

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.
Post Reply