Re: Optimization advice

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 17 Sep 2004 04:17:10 GMT
Message-ID: <azt2d.447772$%_6.367682@attbi_s01>

"Andy Reynolds" <ajreynolds_at_san.removethis.rr.removethis.com> wrote in message news:Xtt2d.7869$XW.206_at_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
> ajreynolds_at_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 Received on Thu Sep 16 2004 - 23:17:10 CDT