Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 27, 2013 11:36 AM by XIII
Jan 26, 2013 12:32 PM|LINK
I am in the process of developing a news website. Now problem that I face is that how do I upload news for the front end.
The approach that I was thinking to follow was that I make an interface in the admin section from where we can upload the articles , save the article in database and show it on the front end. But this approach in long run would make the database alot heavy,
since storing the big articles would create problems as I see.
Is there any better way of doing it ?? So that database does not play much role in it or the method mentioned above is just fine.
Please help ASAP
Jan 26, 2013 12:35 PM|LINK
databases are meant to store such amounts of data. If you worry about data retrieval taking a long time simply make use of caching in the front end layer of your application for (semi) static data. ASP.NET has quite a lot to offer for this. Take a look at
the Cache object and the various output caching capabilities for example.
Jan 26, 2013 12:40 PM|LINK
Thanks for your prompt reply, I just need to know that do I require to do indexing to optimize the performance, or it would be just fine without it also.
Jan 27, 2013 08:42 AM|LINK
Clustered and Non Clustered indexes does help in boosting performance of database retrieval process....probably you might need to also enable FullText Catalog on your long text fields so that search would be also good...I do not see any problem with Data
retrival process...but only with your Search mechanism (if you have any)..for that you have to go for tuning yout select queries with Indexes...it is repetitive process and it is not going to be done in a day.....it takes iterations...
Jan 27, 2013 11:36 AM|LINK
laying correct indexes will for sure help boost performance. Before and after your site is in production you can let run the tool
Database Engine Tuning Advisor.