-
Speed if file is Compressed
I am Using ORCALE 8i on Windows2k Server.
If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
Ok
Thanking U
-
Re: Speed if file is Compressed
Originally posted by bk_raavi
I am Using ORCALE 8i on Windows2k Server.
If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
Ok
Thanking U
you wanna zip files up - and you think oracle will work after that or am i missing something here
-
You are talking about OS compression I guess. Oracle bypasses the OS data access methods - I'd be amazed if it worked.
-
Not zip files up, but compress the directory, I assume... or at least, I hope.
If so, then I have done that on a test box with no performance side-effects... but I wouldn't dream of doing it on a live server. If your company values their data, I would tell them to buy more disk. Its cheap nowadays y'know.
-
See Metalink Note:228082.1
Last edited by marist89; 12-15-2004 at 12:37 PM.
-
Ah, just noticed the version he's using, i.e., 8i
So you need to upgrade to 9ir2 to use this.
-
For everyone else replying
check out the SCOPE & APPLICATION section.....
Tut tut.
-
Re: Speed if file is Compressed
Originally posted by bk_raavi
I am Using ORCALE 8i on Windows2k Server.
If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
Ok
Thanking U
Benchmark it
-
Re: Speed if file is Compressed
Originally posted by bk_raavi
If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
Which so ever might be the compression algorithm, its obvious that the decompression process would take its time as against retrival of data without compression.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Obvious perhaps, but not noticable on my test server.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|