Thread: 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...

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.

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.

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

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