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
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