![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 11 to 16 of 16 total |
![]() |
Wed, Apr 5 2017 6:07 PM | Permanent 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 PM | Permanent Link |
Raul ![]() | 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 AM | Permanent 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 AM | Permanent Link |
Raul ![]() | 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | David,
Sorry, wrong forum: replace "EDB" with "DBISAM" in my last reply. ![]() Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |