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

Strange cookie problem. setcookie dependant on where user was directed from?
Hello,

I have a website that sets a cookie when a user visits the website. The cookie holds a

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

how can we add data from dynamic fields to mysql db in php
i have a script which i found on the internet. i modify that script according to my needs. what is i

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

MYSQL gen help
This is my Mysql gen. can anyone tell me why this echos

MID(networkset.networkid, 3, 3) AS &q

PHP time (deadline within one week)
I have a column ['projdue'], which stores the deadline for a project.
I have PHP code and <

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres