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

Paypal
Hi all,

I have an advanced basic knowledge of php

I want to try something new for a s

Dealing with code in db query
I am dealing with C code and I need to make sure it is encoded some how to ensure its integrity and

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

DOMDocument parsing
Hello, I am parsing an xml file from an API which I have converted into a DOMDocument in php. This i

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so

IMAGE - SERVER SIDE scripting help...
How to receive pixel data of an image and buid a bitmap file on the server using the HTTP POST metho

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

Website Direction...
I recently used this code to try and make it so the page loads as http://www.domain.com/ when you ty