Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Set primary extent size?

Posted on 2007-11-17
8
Medium Priority
?
1,577 Views
Last Modified: 2013-12-24
Hi Experts,

I'm working on an ooooold INFORMIX 5.10 database, and want to change the "primary" extent (if that's what it's called) to say 1.5 times the current size of the loaded data, to maximise performance and allow for 50% growth without going into "secondary" extents (or is it "next"? extents).  The current data is badly fragmented, and the extent sizes are too small, so I plan to export, delete, and import the database.

Questions:

1. What is the correct term for this "primary" extent?

2. Does trying to avoid using next extents sound like a good way to maximise performance?  (Yes, I know there are many other ways - I'm just talking about this one).

3. I know how to set the next extent sizes ("ALTER TABLE...MODIFY NEXT SIZE..."), but how can I go about making the "primary"? extent 50% larger than the current data requirement?

4. Could I achieve item 3 by increasing the row counts in the dbexport file (after the export) by 50%, and then import?

5. Do those row counts in the dbexport file have to match the numbers of rows in the table unload files, for the dbimport to work?

6. Can the primary extent span chunks?  (I understand that next extents can't).

Thanks.
0
Comment
Question by:tel2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 20369104
It is set when initializing server based on config file
General recommendation is 128MB
0
 
LVL 12

Author Comment

by:tel2
ID: 20439024
Hi gheist,

Sorry for the delay in responding.

What variable are you referring to?
0
 
LVL 62

Accepted Solution

by:
gheist earned 500 total points
ID: 20450103
confuded with root dbspace.
it is specified when one does create table.
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 12

Author Comment

by:tel2
ID: 20453442
Hi gheist,

What do you mean by "confuded" (is it "confused"?).

Are you saying I should do this:
  CREATE TABLE abc ... EXTENT SIZE ...
?

TRS
0
 
LVL 62

Expert Comment

by:gheist
ID: 20456928
0
 
LVL 12

Author Comment

by:tel2
ID: 20461947
Awesome!

I'll take that as a double "yes".

Thanks gheist!
0
 
LVL 62

Expert Comment

by:gheist
ID: 20462410
Informix Unleashed is best book on subject - it deals with some internals covered by Informix courses, not everything, but reasonalbly well.
First extent is allocated when table is created, next are allocated later many times and new ones can be set different size by ALTER TABLE
First extent should be data size when you import data, next is expected growth between UPDATE STATISTICS
They should be rounded up to page size (as taken from onstat) - 2k or 4k (8k page systems like old SunOS are long gone)
0
 
LVL 12

Author Comment

by:tel2
ID: 20462424
OK - thanks again, gheist.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question