Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 16 of 16 total
Thread Temp Folder Location
Wed, Apr 5 2017 6:07 PMPermanent Link

David

Ahh of course. Doh!

Ok I will check into that then.  Will compression reduce the size of temp files or is it only done when being transmitted over the wire?

David

Raul wrote:

On 4/5/2017 11:58 AM, David wrote:
> I have one other question and I am a bit baffled. If I run a query, I see the temp files created, I note the size of one file in explorer 167kb but when I right click and check the properties it states 1.9mb on disk.  I assume this is something to do with compression but still baffled.  What I did was I ended the DBISam Server process and instantly the file size shown in explorer increases to match the size reported in the properties window.  Can you explain what is happening to me?.  I modified my app to have remote compression set to 0 but it still operating as described above.  Is the remote compression in C/S controlled by the server or by the session property?

Temp file is open by the DBISAM so windows explorer does not real-time
update the size(press F5 in explorer and it should update). it's not
related to (on the wire) compression at all.

Raul
Wed, Apr 5 2017 11:22 PMPermanent Link

Raul

Team Elevate Team Elevate

On 4/5/2017 6:07 PM, David wrote:
> Ok I will check into that then.  Will compression reduce the size of temp files or is it only done when being transmitted over the wire?

Transmit only. Compression only applies to remote sessions and can
compress data being transferred over network (session Session
RemoteCompression property).

Regular or temp DB tables are never compressed by DBISAM.

Only place i can think of where DBISAM uses file compression is built-in
backup - you can specify compression level for backup.

Raul




Thu, Apr 6 2017 5:25 AMPermanent Link

David

Thanks Raul.

I presume that Temp files are generated by the server then compressed when sending to clients though. Providing you have compression set in the first place?

Raul wrote:

On 4/5/2017 6:07 PM, David wrote:
> Ok I will check into that then.  Will compression reduce the size of temp files or is it only done when being transmitted over the wire?

Transmit only. Compression only applies to remote sessions and can
compress data being transferred over network (session Session
RemoteCompression property).

Regular or temp DB tables are never compressed by DBISAM.

Only place i can think of where DBISAM uses file compression is built-in
backup - you can specify compression level for backup.

Raul
Thu, Apr 6 2017 8:22 AMPermanent Link

Raul

Team Elevate Team Elevate

On 4/6/2017 5:25 AM, David wrote:
> I presume that Temp files are generated by the server then compressed when sending to clients though. Providing you have compression set in the first place?

Yes. Everything server sends when compression is enabled gets compressed
- however compression is at block/buffer level during actual send and
not at file level.

Non-live/canned queries are usual source of temp files but anything else
server transmits also is compressed in that case - table navigation
results, live query results, etc and none of those use temp files.

Raul

Wed, Apr 19 2017 1:34 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

David,

<< I presume that Temp files are generated by the server then compressed when sending to clients though. >>

EDB never sends temporary files over to the client, at least not as an entire file.  They are always kept on the server-side.

EDB may send over *rows* that are in temporary tables, but they are sent over on as-required basis.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Apr 19 2017 1:35 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

David,

Sorry, wrong forum: replace "EDB" with "DBISAM" in my last reply. Smile

Tim Young
Elevate Software
www.elevatesoft.com
« Previous PagePage 2 of 2
Jump to Page:  1 2
Image