Performance Tuning Tips

Performance Tuning Tips

Post by Dirk Moolm » Sat, 16 Jun 2007 22:21:48


:-)


ftp://ftp.software.ibm.com/software/data/informix/ids/perf-tuning-tips.p
df







Dirk Moolman
Database and Unix Administrator
Agility Technologies (HealthCorp)



"People demand freedom of speech as a compensation for the freedom of
thought which they seldom use."




*** Disclaimer ***

The information contained in this e-mail is confidential and legally privileged and is intended solely for the addressee and to others who have the authority to receive it. Access to this e-mail by anyone else is unauthorized and as such, any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. If you have received this e-mail in error, please notify the sender immediately.

The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of the Company.

The Company is not liable to ensure that outgoing e-mails are virus-free.

The Company is not liable, should information or data, for whatever reason, be corrupted or fail to reach its intended addressee.

The Company is not liable for any loss or damage of whatsoever nature and howsoever arising resulting from the opening or the use of the information in this e-mail, including its attachments and links.

The sender of this e-mail is subject to and bound by the terms and conditions of Company+IBk-s Electronic Communications Usage Policy.
 
 
 

1. Secret Java Performance Tuning Tip

2. FYI - Performance Tuning Tip for SQL Server 2000 with Federated Model

This is a multi-part message in MIME format.


We just recently encountered this and I thought I'd pass it on.

If you are using SQL parameters for updates, make sure your parameters EXACTLY match the size of VARCHAR fields. If they don't, the procedures will run practically forever.

--
TIM ELLISON
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.3790.2491" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>We just recently encountered this and I thought I'd
pass it on.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If you are using SQL parameters for updates, make
sure your parameters EXACTLY match the size of VARCHAR fields.  If they
don't, the procedures will run practically forever.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-- <BR>TIM ELLISON</FONT></DIV></BODY></HTML>

3. Performance tuning tips required for bind 9.6.1-P3!!!

4. SQL Performance Tuning Tips

5. Performance Tuning Tips for SQL Server 2000

6. General Question about Performance/Tuning and scheduled Tuning

7. Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

8. Diet Tips, Weight loss tips, Make Up tips, Parenting Tips

9. Sendmail Tuning tips - requierd

10. Travel Tunes Tip

11. Tips for Tuning Windows for SQL 2005 ?

12. Vista Tuning and Tips blog / site?

13. Vista tips/tricks/tuning Blog web site?

14. Oracle IO tuning tips/practices on Windows

15. Tuning Tips Needed for the Code