Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 03-09-2009
Member
 
Join Date: Jun 2009
Posts: 96
How do you optimize your database

I am running a small web application. My problem is that it takes a lot of time to perform any tasks. This is affecting me a lot in several ways. I want to optimize my database. How should I proceed? What all measures do I need to consider in the process of optimization?
Reply With Quote
  #2  
Old 03-09-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: How do you optimize your database

There are several points that should be taken care while optimizing the database. First thing is that always use a WHERE clause to narrow the number of rows returned. Avoid using asterisks (*) since because it returns you all column values in a query, instead use the column name which you want. Try use DISTINCT clause in your query. It allows you to return only unique row values by removing all the duplicates.
Reply With Quote
  #3  
Old 03-09-2009
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: How do you optimize your database

phpMyAdmin is the best tool for you. It is an open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions. It can perform analysis, repair and optimization tasks for your database.
Reply With Quote
  #4  
Old 03-09-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: How do you optimize your database

Keep your tables and queries simple with minimum columns which will finally result in limited calculations. Try to include TOP operator in your query which returns only a certain number or percentage of items in the query. It has been seen that people keep some unnecessary codes that simply does nothing. Always monitor your codes, database and queries and delete anything that is not required. At last put a higher module of RAM in the server to fasten the speed of operations.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How do you optimize your database"
Thread Thread Starter Forum Replies Last Post
Optimize the connection to the database in mysql Bottlenecked Software Development 8 09-09-2010 10:24 PM
Creating Database link in database Lachlann Software Development 3 28-01-2010 01:17 PM
Optimize performance on a SQL Database Eber Software Development 4 05-11-2009 09:41 PM
convert filemaker pro database to access database Czack MS Office Support 3 15-04-2007 01:06 AM


All times are GMT +5.5. The time now is 08:14 AM.