LIMIT V4MD1

[Ruslan Zasukhin]

On 5/4/05 3:00 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

> Well not really...if I have a DB with some 100000 records and I do a "SELECT
> * FROM TABLE" then I will create a huge cursor and need a lot of RAM and
> speed, not? 

    100,000 * 4 = 400Kb of RAM.

    10 such cursors = 4MB

    100 such cursors - 40 MB


Your server have 100 users in the same time?  :-)


> While a LIMIT 1 would decrease ressource consuming a lot.

Right. 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]