How can you performance tune your database?, JAVA Programming

Assignment Help:

1. De normalizes your tables where required.

2. Proper use of index columns: An index based on numeric parts is more efficient than an index based on character columns.

3. Replace the number of columns that build up a composite key.

4. Proper partitioning of tablespaces and makes a special tablespace for special data types like CLOB, BLOB etc.

5. Data access performance can be tuned by using stored procedures or macros to crunch data in the database server to replace the network overhead and also caching data within your application to reduce the number of accesses.

 


Related Discussions:- How can you performance tune your database?

Regex , Having trouble with a lab, need to

Having trouble with a lab, need to

Explain the basic applet life cycle, Explain the Basic Applet Life Cycle ? ...

Explain the Basic Applet Life Cycle ? 1. The browser reads the HTML page and seraches any tags. 2. The browser parses the tag to search the CODE and possibly CODEBASE att

What is includeaction, The IncludeAction class is useful when you require t...

The IncludeAction class is useful when you require to integrate Struts into an application that uses Servlets. Use the IncludeAction class to contain another resource in the respon

Retrieving data from Excel file , how to retrieve data from Excel file, and...

how to retrieve data from Excel file, and display that data in table on jsp page?

What do you understand by the term constructor in java, Question: (a) ...

Question: (a) What are the main differences between an object and a class? Illustrate with appropriate examples. (b) Differentiate between a global variable and a local va

Draw hierarchy of the people involved in the project, Suppose we have a big...

Suppose we have a big project. Draw hierarchy of the people involved in the project? Executive Team CEO, COO, CMSO Quality Architecture Team Business Development Team Technolog

java garbage collector? , Each time an object is operated in Java, it goes...

Each time an object is operated in Java, it goes into the area of memory named as heap. The Java heap is named the garbage collectable heap. The garbage collection may not be force

Create a generic class with a type parameter, 1. The purpose of this proble...

1. The purpose of this problem is to practice using generics.  Create a generic class with a type parameter that simulates drawing an item at random out of a box. For exampl

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd