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

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows

SQL>

Problem assigning value to variable in "IF" function
Does this script makes sense? I am trying to take the value that is set to "authenticat" a

Table colours fail when extra row added
Hey Gurus,

I got a weird problem with formating the colour of a table made in php. Everything

Searching keywords from array
Hello everyone, Im just wondering if someone could help me with another issue im having. Im still le

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

imap: how to save a copy of sent emails to sent elements
Hello my friends,

I am writing an online emailing application with inbox outbox/sent elements

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

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