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

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

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

Unexpected T_Variable ?
Hi all,
I dont really know what I am doing!! I know I'm doing something wrong, and I know its on

Table sorting
Hi,

I'm trying to modify the following in order to make the output table sorted alphabeticall

Grabbing Values From an Array for Posting
I have a grid array that I am using with a form that when it hits the currently named test.php it lo

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

need help in dynamic select menu in php
hi i have created a dynamic select menu using php. i have a problem in that which is when the user s

firefox wouldnt stream mp3 files completely from my php page
hi everyone,
I have a php file trying to read and stream mp3 files. It works fine in IE but my pr

Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to