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

Code Help.. If txt input box empty search X instead..
I am having a problem with my search script. At current it will simply search by a selected date whi

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

Problem with variable declaration in switch statement
Hello, I am having some trouble assigning a value to a variable inside a switch statement. What I a

Help with usergroups? prolly really quick
So were coding our own forums for a game system we made an we have the users level setup but now I n

Probably Easy, Need help with Check Boxes in PHP Code
hello,

Thanks for looking this over and helping me out. My problem is I have a online store l

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Thought I has this figured out especially after all the help i received?
Cags, Salathe, Daniel helped me with this yesterday, but not sure i took it all in.
I am attempti

Rss feed question
Hi

My blog and my website are different. Am i able to take my rss feed
from my blog and p

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code: