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

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

unserialize help, getting errors
hi all ,
I got a form with 6 fields (2 input and 4 select box), when the page loads one block is

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

Uploading files/images via forms
Hey all, I am building a database for work that will contain some minor data on plant species along

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Export hangs
Hi all, please help

I have a Oracle 10.2.0.3.0 database. When I want to query the dba_segmen

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

Sufficient protection from bad input?
I am writing a simple script to let people upload 'pages' of their own content, be it simply a few b