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

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

Simple MySQL script is not working
Hey guys,

Just familiarizing myself with PHP and MySQL. I am following along in the O'Reilly

How do I send data using an html link
Hi

If I have
<a href="main_file.php">

How do I send data t

From Header Showing 'Unkown' In Hotmail? Why?
Code: $to = $row_GetID['email_addr'].',sales@mywebaddress.co.uk';
$subject = 'Thank you for you

Multi-user card game
I'm writing a batch of games and such. Lottery is finished, Poker,blackjack,etc are next. They will

Login logout link help
Hi all,

Im new to php and Im having trouble creating a login/logout link for my page that dis

MySQL Primary key gap
Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (ht

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put

Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';
and ha

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