Last post Aug 01, 2014 11:38 AM by twice
Jul 31, 2014 09:56 PM|romeo407|LINK
I have a website that is sort of a forum that uses a lot of inserts and also a lot of searchs my issue is that having an index on that database table would slow inserts but the searchs can really use an index to speed up the search time to retrieve records;
would it be viable to have 2 tables of the same data but 1 of them to use an index just to read & search and the other table to not have an index and use that one for inserts. I am relatively new to databases but would welcome any suggestions..
Aug 01, 2014 07:09 AM|twice|LINK
What is "a lot of inserts"? Have you tried it and checked how it affects performance? Having another 'table' is just pushing the problem elsewhere, in this case the disk/space requirement.
Aug 01, 2014 09:21 AM|romeo407|LINK
What I meant by a lot of inserts is that generally I average about 50,000 to 60,000 new insertion records per day.
Aug 01, 2014 11:38 AM|twice|LINK
Okay it seems like a fair amount however I don't think anyone can give you what 'exactly' to do. You'll most likely have to play around with as it'll also depend on your hardware, platform, environment and load. If you can afford it, as in complexity-wise
also, then you could distribute and have a query/read-only server.
A book I can recommend is http://db-book.com and a good online resource is: http://use-the-index-luke.com other than that you'll have to try for yourself.