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

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
C++ Http request? 
Code:
	 string Response = "LOGIN_UNSUCCESSFUL";
                System.Net.WebRequest request = Sy
selectbox+database connection retrive problem 
Code: [Select]
 <tr>
            <th align="left" scope="c
PHP SUBMIT 
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg
help with multi-update  
Now sure how to ask this really....

10g database if that matters.



I have a customer 
LIMIT $start, 10... how to pass last value queried into next page with GET?? 
Ok I know how to display the first or last 10 results of  a query...

$result = mysql_query(&q
Mass activity scheduling 
Hi experts,



Im facing some problems to deal with mass activity jobs.

When I run some
Convert array to string and write to csv file 
I am looking to write a MySQL query to a csv file.

At the minute I:

check for the orig