Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Thu, May 8 2008 5:09 PM	Permanent Link
"Jose Eduardo Helminsky"	If I set full compress to ALL my indexes the process of indexing should be slower than without compression ? Eduardo
Fri, May 9 2008 5:36 AM	Permanent Link
"Enrico Ghezzi"	> If I set full compress to ALL my indexes the process of indexing should > be slower than without compression ? Hi Eduardo Good question i add the comparison for Read Operation and Write Operation. For Only Read Operation , which is the best index compression method ? For Read / Write Operation , which is the best index compression method ?
Fri, May 9 2008 2:32 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Eduardo, << If I set full compress to ALL my indexes the process of indexing should be slower than without compression ? >> The speed improvements from compression are primarily geared towards reads rather than writes, so yes, this is possible. -- Tim Young Elevate Software www.elevatesoft.com
Fri, May 9 2008 2:34 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Enrico, << For Only Read Operation , which is the best index compression method ? For Read / Write Operation , which is the best index compression method ? >> There is no particular better compression for reads vs. writes. The best compression method aims to reduce the amount of I/O, period: http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=d&version=7&category=2&topic=5 -- Tim Young Elevate Software www.elevatesoft.com