470,604 Members | 2,014 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,604 developers. It's quick & easy.

Optimization advice

I am looking for information, books, websites, etc that will help me figure
out the following things in MSSQL and Oracle:

1. Optimizing the database configuration itself.
2. Optimal table and index design.
3. Optimizing SQL statement lookups.
4. Anything else that might help to speed up our database applications.

Any advice at all would be useful.

Thanks alot.

Andy Reynolds
aj********@san.no.spam.rr.com (remove the no.spam to send email)
Jul 19 '05 #1
4 4041

"Andy Reynolds" <aj********@san.removethis.rr.removethis.com> wrote in
message news:Xt***************@twister.socal.rr.com...
I am looking for information, books, websites, etc that will help me figure out the following things in MSSQL and Oracle:

1. Optimizing the database configuration itself.
2. Optimal table and index design.
3. Optimizing SQL statement lookups.
4. Anything else that might help to speed up our database applications.

Any advice at all would be useful.

Thanks alot.

Andy Reynolds
aj********@san.no.spam.rr.com (remove the no.spam to send email)

Optimize the application.
Use bind variables
Get data efficiently, use array interface.
Avoid unnecessary parsing.
write efficient queries.

If you don't do the above then the rest is useless or of little value.
Jim
Jul 19 '05 #2
Andy

There are several good works on these subjects, check out Amazon for a
few ideas.

Can recommend High Performance Oracle by Ingram -- it touches on all
of the points you raise and is a good intro text.

Rgds Mark

On Fri, 17 Sep 2004 04:11:35 GMT, "Andy Reynolds"
<aj********@san.removethis.rr.removethis.com> wrote:
I am looking for information, books, websites, etc that will help me figure
out the following things in MSSQL and Oracle:

1. Optimizing the database configuration itself.
2. Optimal table and index design.
3. Optimizing SQL statement lookups.
4. Anything else that might help to speed up our database applications.

Any advice at all would be useful.

Thanks alot.

Andy Reynolds
aj********@san.no.spam.rr.com (remove the no.spam to send email)


Jul 19 '05 #3
Jim Kennedy wrote:

"Andy Reynolds" <aj********@san.removethis.rr.removethis.com> wrote in
message news:Xt***************@twister.socal.rr.com...
I am looking for information, books, websites, etc that will help me

figure
out the following things in MSSQL and Oracle:

1. Optimizing the database configuration itself.
2. Optimal table and index design.
3. Optimizing SQL statement lookups.
4. Anything else that might help to speed up our database applications.

Any advice at all would be useful.

Thanks alot.

Andy Reynolds
aj********@san.no.spam.rr.com (remove the no.spam to send email)

Optimize the application.
Use bind variables
Get data efficiently, use array interface.
Avoid unnecessary parsing.
write efficient queries.

If you don't do the above then the rest is useless or of little value.
Jim


Your list being in context of Oracle. Supporting your list ...

.... as described in Jonathan Lewis' "Practical Oracle8i" (and valuable even
now with 10g), Thomas Kyte's "Effective Oracle by Design", other books by
OakTable members (http://www.oaktable.org), and in the Oracle documents
such as "Application Developer's Guide - Fundamentals" at
http://docs.oracle.com

And adding to your list ...

Don't use DDL (creates, drops, alters) at run time
Learn Oracle's Global Temp Tables before diving into the Temp Table mill
Don't commit in loops
Don't use procedures where set operations will do
Do use stored procedures
Don't reinvent the wheel. Consider using Oracle's built-in
- workflow
- message queueing
- geospatial (Locator), Document (Text), multimedia (Intermedia)
- security (Row Level Security & Policy-based statement re-write)
- auditing
- direct http interaction (frequently replaces ASP, Perl)
- direct file, tcp interaction
- job scheduler
- external procedures
- external tables
- and so on
Don't use same development techniques for Oracle and MS SqlServer
- due to different locking internals, different techniques MUST be used!

(BTW - the comp.database.oracle.* heirarchy and the group
comp.databases.oracle are rogue - please help bring the lost souls back to
comp.databases.oracle.* per the charters copied at http://orafaq.com)

/Hans
Jul 19 '05 #4
Andy Reynolds wrote:
I am looking for information, books, websites, etc that will help me figure
out the following things in MSSQL and Oracle:

1. Optimizing the database configuration itself.
2. Optimal table and index design.
3. Optimizing SQL statement lookups.
4. Anything else that might help to speed up our database applications.

Any advice at all would be useful.

Thanks alot.

Andy Reynolds
aj********@san.no.spam.rr.com (remove the no.spam to send email)

Try http://www.oracle.com/technology//index.html for info on Oracle.
Registration is free.
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Mike and Jo | last post: by
2 posts views Thread by rocky | last post: by
3 posts views Thread by Andy Reynolds | last post: by
1 post views Thread by Dave | last post: by
9 posts views Thread by Rune | last post: by
reply views Thread by qonhfmwfyrqx | last post: by
9 posts views Thread by Amod | last post: by
20 posts views Thread by Ravikiran | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.