SQL Table Setup Advice

Posted by Ozzy on Stack Overflow See other posts from Stack Overflow or by Ozzy
Published on 2010-04-14T13:45:27Z Indexed on 2010/04/14 13:53 UTC
Read the original article Hit count: 332

Filed under:
|
|
|
|

Hi all. Basically I have an xml feed from an offsite server.

The xml feed has one parameter ?value=n now N can only be between 1 and 30

What ever value i pick, there will always be 4000 rows returned from the XML file. My script will call this xml file 30 times for each value once a day. So thats 120000 rows. I will be doing quite complicated queries on these rows. But the main thing is I will always filter by value first so SELECT * WHERE value = 'N' etc. That will ALWAYS be used.

Now is it better to have one table where all 120k rows are stored? or 30 tables were 4k rows are stored?

EDIT: the SQL database in question will be MySQL

© Stack Overflow or respective owner

Related posts about sql

Related posts about query