Re: Approximations

Subject: Re: Approximations
From: Kasey Chang <KaseyC -at- DISCOPY -dot- COM>
Date: Tue, 11 Oct 1994 11:04:00 PDT

>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?

How about just "approximately"?

X. Use the PREPARE statement for SQL statements that an application uses
_approximately_ 10 times.

Sounds okay... Then you need to explain why. :-)

--Kasey Chang


Previous by Author: Re: Re[4]: How one fellow sees us
Next by Author: Re: Request for Information on Productivity
Previous by Thread: Approximations
Next by Thread: Re: Approximations


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


Sponsored Ads