Approximations

Subject: Approximations
From: Lallie Heard <lheard -at- ST6000 -dot- SCT -dot- EDU>
Date: Tue, 11 Oct 1994 13:35:45 -0400

Opinions, please. Here are two versions of a standard that tells users
when they should use a particular command:

1. Use the PREPARE statement for SQL statements that an application uses
_many_ times.

2. Use the PREPARE statement for SQL statements that an application uses
_more than about 10_ times.

The problem seems to be that what constitutes "many" is in the eyes of
the beholder. It's arbitrary, depending on many undefinable variables. Too
much use of a statement by an application results in degradation of the
performance of the application, but depending on what statement is being
used and the amount of data being returned, what might be "many" in one
situation could be "hardly any" in another. I don't think "more than
about" a finite number helps much. What to do?

Lallie Heard
lheard -at- st6000 -dot- sct -dot- edu


Previous by Author: Thanks for responses
Next by Author: Approximations
Previous by Thread: Re: Cue Cards
Next by Thread: Re: Approximations


What this post helpful? Share it with friends and colleagues:


Sponsored Ads