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

please help
HTML Code:

Code: <span id="ctl00"><span>

Modal Popup Help
Hi guys, I have a modal popup with an iframe. How can i send data from a label or textbox to the ifr

Best way to read this text file.
Hi.I am planning to make a small application in C# to convert the players from Football manager 2010

Need help in Generating Combinations
Need help generating all possible combination of names in an array

Lets say i have the follow

Problem in back link
I have page where i have given javascript back link but when i click on it browser give a message

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

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.

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the