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 05-11-2009
Member
 
Join Date: Nov 2009
Posts: 610
What are the ways to manage a database more efficiently

Hi,
We have a site which is linked to a user database. This database provide queries of different types of products offered by the company. Some time the users complain that the site takes a longer time to respond to a given query. I need some suggestions on how to manage a database in SQL server more efficiently. The pages and links sometimes gives out hard times. Also what is the syntax to specify a index in the existing database. Thanks.
Reply With Quote
  #2  
Old 05-11-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: What are the ways to manage a database more efficiently

In portal type pages where the sides are links that are printed from databases (different sections, services ,...) there is always a retarder effect because it is highly visited pages to make multiple calls BD systematically in each of your pages. One way to speed up the display of these pages is textualized these links from internal scripts.
Reply With Quote
  #3  
Old 05-11-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: What are the ways to manage a database more efficiently

The links are displayed on the page have not been determined for calls to databases but, each time a new element of the section is added, it updates itself automatically, using a script, a text file which the new link is included and the oldest is removed. It is, in fact, this text file that is inserted into the page source code. In this way we avoid a half dozen calls to databases each time a page is viewed which enables to optimize server resources in a meaningful way.
Reply With Quote
  #4  
Old 05-11-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: What are the ways to manage a database more efficiently

In situations in which our database has to store extremely long text fields and these fields are required to make selections of type LIKE '% something%', the resources of the Database can be appreciably reduced. One way to help manage these searches is including an additional field. This additional field can be created automatically through scripts and it would include the original text, which we will have eliminated trivial words such as articles, prepositions or possessive. We will also remove the words that are repeated. This allows us to considerably reduce the size of the field to be truly consulted.
Reply With Quote
  #5  
Old 05-11-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: What are the ways to manage a database more efficiently

In general, most databases have powerful editors of bases that allow quick and easy creation of any table with any type of format. However, once the database is hosted on the server, it may be the case that we want to introduce a new table, either temporarily (to manage a shopping cart for example) or permanent specific needs of our application . In these cases, we can, from a SQL statement, create the table with the format you want which you can save more than a headache. Such judgments are especially useful for databases such as MySQL, which work directly with SQL commands and not by editors. To create a table must specify various information: The name you want to assign the field names and characteristics. And it may be necessary to specify which of these fields will be and what kind of rates will be. The syntax of creation can vary slightly from one database to another as the field types are not fully accepted standard. Syntax - Create Table table_name (xxx_xx_1 xxx_1 , xxx_xx_2 xxx_2, xxx_xx_n xxx_n , Key (xxx_x ,...))
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What are the ways to manage a database more efficiently"
Thread Thread Starter Forum Replies Last Post
How to manage SharePoint content database? Fanishwar Software Development 5 05-01-2011 11:27 PM
How to use MS project 2007 to manage projects efficiently and effectively? emily01 Windows Software 3 29-09-2010 04:51 PM
Three ways to manage utorrent on iPhone / iPod touch SoftWore Tips & Tweaks 3 21-06-2010 05:21 PM
RSM cannot manage library CdRom0. The database is corrupt. JoshP Windows Server Help 1 25-05-2009 08:45 PM
5 ways to use Gmail effectively & more efficiently ChrisUlrich Tips & Tweaks 7 30-12-2008 07:45 PM


All times are GMT +5.5. The time now is 03:53 PM.