Re: Question on tblspace tblspace

Pingu !!! Guess Who !! I have done a little research into this little baby and found the following:- tblspace tblspace is assigned by the server as and when required and adds 50 pages at a time ( default ) whenever a tblspace tblspace needs to be increased. As you have found out, the tblspace tblspace gets rather fragmented but this shouldn't be too much of an issue as each tblspace tblspace holds information about different tables ( rather than a linked list of the same table information being passwd from tblspace to tblspace ). I eventually got the information back from my server and we also have hundreds of tblspace tblspaces scattered around the database ( 41GB worth ) and we have not encountered any adverse performance problems. I have spoken to ITS about it ( as a pssing comment ) and they said not to worry as the engine adds space as and when it needs it. Hope this helps. If you find anymore about it I'd like to know !! Thanks Sean ethump5724@my-dejanews.com wrote in message <72v038$c73$1@nnrp1.dejanews.com>... >Hello Informix World > >I'm currently installing a Online 7.30 system for a client and loading around >10Gig of data into two databases. At the moment I'm not specifying extent >sizes on the tables because I'm letting Informix handle it with it's "extent >doubling" capabilities > >What I'm finding is that all of my tables when loaded have one extent BUT in >the entire Online instance I have around 15 tblspace tblspace 's all with an >extent size of 50. > >Is there a way of increasing the extent size for tblspace tblspace, I'm not >altogether sure but it must be better to have one tblspace tblspace instead of >many scattered all over my chunk(s) > >I would be grateful if you could email me if you have any ideas > >Thanks >Paul Eccleston > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own