Kane250 Posted March 30, 2009 Share Posted March 30, 2009 Hi, I don't use MySQL all that much and this is probably a dumb question, but I could definitely use some advice. I have a web app that is taking paragraphs, splitting them up into sentences, and inserting each sentence separately into a table with a unique ID so I can sort which ones came from where. ex: table: para1 entry: I am a sentence id: 1234 table: para2 entry: I am a sentence id: 1234 table: para1 entry: I am a sentence id: 0999 table: para2 entry: I am a sentence id: 0999 These tables will have pretty heavy amounts of text flowing into them over time, and I'm wondering when a table is too large and another should be created. I would think that if I only used the one table forever, performance would get very slow when calling back all those entries. I also thought I might just create a new table for each paragraph and it's unique ID...like this: table: 1234para1 entry: I am a sentence table: 1234para2 entry: I am a sentence table: 0999para1 entry: I am a sentence table: 0999para2 entry: I am a sentence I really don't know which is going to be better for performance. I was told that creating a ton of tables is bad, but I feel like filling up 1 table with possibly thousands of entries could be equally as bad? Any ideas? Thanks in advance! Quote Link to comment https://forums.phpfreaks.com/topic/151839-when-to-create-new-tables/ Share on other sites More sharing options...
taquitosensei Posted March 31, 2009 Share Posted March 31, 2009 thousands of entries is nothin' I had a table with over 4 million entries with not much of a performance hit. I knew but nobody using my app did. Quote Link to comment https://forums.phpfreaks.com/topic/151839-when-to-create-new-tables/#findComment-797445 Share on other sites More sharing options...
Kane250 Posted March 31, 2009 Author Share Posted March 31, 2009 Wow, so even when pulling a list of a few hundred entries at a time from within thousands, it's still pretty quick? I had no idea. Do you agree then that making a ton of new tables is a poor method? Quote Link to comment https://forums.phpfreaks.com/topic/151839-when-to-create-new-tables/#findComment-798054 Share on other sites More sharing options...
Maq Posted March 31, 2009 Share Posted March 31, 2009 Do you agree then that making a ton of new tables is a poor method? You should read about, Database Normalization. Quote Link to comment https://forums.phpfreaks.com/topic/151839-when-to-create-new-tables/#findComment-798062 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.