Structure Question - One Table or One Table Per Record Set?

Posted on 16th Feb 2014 07:03 pm by admin

I have a web app (mySQL and PHP) which allows people to create an item with up to 200 records which I store in a single table. Any user subscribing to that item will be pulling up to 4 records from the original 100 records each time they load a page. Sometimes the 4 records are chosen randomly and could take many selects to get 4 correct records.

I expect thousands of items to be created, which could lead to millions of records and thousands of millions (I think they call them billions) of selects.

Will this approach scale or should I be creating new tables for each set of records? This could lead to thousands of tables on the DB. Any problems there?

Your Answer:

Login to answer

Other forums

Renaming array keys
The issue: renaming array keys inside a foreach loop.

I'm trying to build a pie chart image w

upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi

I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.

Echoing If Function?
A script I am using has If statements in the comments form to basically tell the form what to do. Cu

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if

How do I use a global footer..?
If my index.php has a bole bunch of if functions and exit's in them

How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul

Can I use a loop
Hi buddies!

Once again with my doubts here.

Right now I am using this sql stat

Problem with PHP/mySQL login code
Hello,

There is an error in my login script and I can't figure out what it is...
I believe