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

How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of

Multiple Pages
Hi. Im very new to php. I'm trying to create a basic login/registration page.

So I have a bas

problem with GROUP BY and ORDER BY
i usually use this query to display the last 10 entries from a sql table:

Code: $query = &quo

Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb

Change Sort Order to Display Newest File First
Hi Guys,

I have a page that sorts the contents (PDFs) of a directory and displays them on the

DYNPRO_FIELD_CONVERSION
Hi gurus,

I got a dump when I run one of my program. the dump is described below:

Sort Alternative/bi-monthly
Hi all,

Am going mad trying to get something to work.

I'm creating a CMS for a magazi

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

If a form submits back to same page do you need to use $get
IM trying to pass page number and year that was selected back to the same page.

i have this c