What are the ways to manage a database more efficiently

[Elbanco]

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.

[MindSpace]

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.

[Modifier]

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.

[Praetor]

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.

[Katty]

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 ,...))