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.

Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
265 Like 24 Dislike
Previous forums Next forums
Other forums

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

Typing math
I've added support for typesetting math using LaTeX on the forums.

Example:
Code: [Select]

Grouping and sorting results
Please help with this query.

I have 2 tables in a database, countires and cities. states look

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash