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

AJAX form submit
I recently built a form that submits data to my database with an ajax function that is called throug

Socket Server Response Headers
Earlier I had a post about my Socket Server, I wasn't able to get it to connect, now I can

I

Downloading file (Headers)
I'm trying to make users download a file, but they must wait 60 seconds before it begins.

But

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

Call to undefined function mysql_fetch_accoc()
New to php/mysql coding. What's wrong with this sequence, or am I
just not seeing to obvious?

Echoing ASCII code
I have a php page that splits a string into chars and then echoes the ASCII code for each char. I'm

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

How To Make More Than One Redirection with PHP on the same page?
Hey im trying to do a direction page where it open differently link direction pages every time som

Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo