dbTalk Databases Forums  

Re: Slow database creation and loading

comp.databases.informix comp.databases.informix


Discuss Re: Slow database creation and loading in the comp.databases.informix forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #21  
Old   
Superboer
 
Posts: n/a

Default Re: Slow database creation and loading - 06-28-2007 , 03:29 PM






a couple more things:

can you post the timings like
set pdqpriority 100;

select current from systables where tabname = systables;
create index......
select current from systables where tabname = systables;

i sure hope you do not create a clustered index.... if you do, then
don ' t

also if you have foreighn key constraints you may have a problem.
do no if this is adressed in your version or in a later one.
The problem is that fk constraints are/were not processed in paralel.
a fellow called johnp filed that fea req /bug a looooonnng time ago
against V6.

If you create that fk and use pdq have a look at onstat -g ses <sid>
for the number of threads.

Superboer.



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 - 2009, Jelsoft Enterprises Ltd.