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

Help Import Animoto and Youtube
CAn someone help me urgently want to allow users on my website to import youtube/revver/dailymotion

I think i'm using the syntax incorrectly
Hi Everyone!

I'm new to this forum and a newbie with PHP - I'm glad I found this site - I hop

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

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

using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and

listcube issue
Hi
I have a virtual cube ZREMOTE. I use Tcode "listcube" to retrieve contents. I use of the

Deleting Partners on the Customer Master.
Does SAP handle removing the Partner from Open Sales Orders when a Partner is deleted in the Custome

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli