dbTalk Databases Forums  

performance question

comp.databases.sybase comp.databases.sybase


Discuss performance question in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
A Prit
 
Posts: n/a

Default performance question - 01-07-2004 , 09:19 AM






Hello,

I have about 14G database - one device, one segment (default),
physically located on one scsi channel. There are few tables having
text type of the columnt (totaling probably 10M records). My question
is: would I gain any performance if I create separate device (on the
same scsi channel) and put a text segment there.

TIA
aprit

Reply With Quote
  #2  
Old   
Pablo Sanchez
 
Posts: n/a

Default Re: performance question - 01-07-2004 , 12:03 PM






aprit (AT) hotmail (DOT) com (A Prit) wrote in news:7eb83165.0401070719.57d65179
@posting.google.com:

Quote:
I have about 14G database - one device, one segment (default),
physically located on one scsi channel. There are few tables having
text type of the columnt (totaling probably 10M records). My
question is: would I gain any performance if I create separate
device (on the same scsi channel) and put a text segment there.
Until you get more disk drives, I wouldn't do a thing.
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.