Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Temp-Query-Results in Memory
Wed, Nov 14 2007 4:44 PMPermanent Link

"Ralf Graap"
Hey Tim,

i would like to see a possibility to hold the Results of temp. Queries per
Default in Memory and not in a 12345.dat-File.

I often have to do a lot (>> 10000) of very small Query's with Recordcount <
10.
Each of the "Dat"-Files is checked by my Virus-Scanner (McAfee).

Sometimes i get an Error like: 12345.dat not found.

Now i use a workaround with "select into memory tmpRes".

It helps, but i think it isn't very smart because i must handle the
exclusive use of the Tablenames and the new Table tmpRes isn't droped
automaticly when the query is closed.

I would like to see an Property for TDBISAMQuery/TEDBQuery like
 ResultInMemory: Boolean     // True: All Results a hold in Memory
   or
 MemoryResultLimit: Integer; // All Results lower x Bytes a hold in Memory.

Thx
 Ralf

Thu, Nov 15 2007 5:07 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ralf,

<< I would like to see an Property for TDBISAMQuery/TEDBQuery like
ResultInMemory: Boolean     // True: All Results a hold in Memory
   or
 MemoryResultLimit: Integer; // All Results lower x Bytes a hold in Memory.
>>

I will see what I can do.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Nov 15 2007 5:15 PMPermanent Link

"Fons Neelen"
Hi Tim,

This would be ideal for me too. I would appreciate if this features would
also work in a C/S environment where the RAM of the server would be
utilized.

Best regards,
Fons
Fri, Nov 16 2007 5:37 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Fons,

<< This would be ideal for me too. I would appreciate if this features would
also work in a C/S environment where the RAM of the server would be
utilized. >>

Yes, that would be the case if/when we implement something like this.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Nov 17 2007 2:33 PMPermanent Link

"Ralf Graap"
Hey Tim,

> Yes, that would be the case if/when we implement something like this.

Please "when" .... not "if" Smile

Ralf

Mon, Nov 19 2007 3:25 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ralf,

<< Please "when" .... not "if" Smile >>

Well, the issue is that ElevateDB is usually a "when" while DBISAM is
sometimes an "if" now.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image