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

Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

trim function issues
Hi guys, total noob here...

So I've been tinkering around with a html and am using php to em

Problem with PHP code- simple contact form
Hi Folks,
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a co

PHP and XML image gallery variable issue
I'm trying to display the large image on the same page as the thumbnails, to do that I'm passing a v

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

IF Statement & Two Tables With Different Echoes
I'm retrieving two tables in a single query using UNION ALL, like so:

Code: $query = "SE

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen