Re: Onload is too slow

In article <35BCE7AF.2711@bellsouth.net>, carlson1@bellsouth.net wrote: > Raghava Ponnapalli wrote: > > > > Hello, > > > > We have 1.2 G database that's taking about 2-3 hrs to load using onload > > from a flat file. I turn off logging when I onunload. This is 7.13 UC2 on > > Solaris 2.4. Here are some of our settings for onload: > > OK . . . logging is off . . . > > > > > LRU_MAX_DIRTY = 5 > > LRU_MIN_DIRTY = 4 > > BUFFERS = 131072 > > CLEANERS = 7 > > PHYSFILE = 58000 > > CPU VPs =6 (= # of CPUs) > > RA_PAGES = 32 > > RA_THRESHOLD = 16 > > AIO = 2 > > KAIO = 6> > > > Check points are still taking too long (85 to 300 secs) since PHYSFILE is > > reaching 75 % too quickly. This PHYSFILE (58000) is our max . Can someone > > tell me how I can speed this up. > > Drop indices and recreate afterwards. Much more efficient. > > > > > onstat -g ioq tells me that each KAIO's maxlen is around > 140 except for> > one (which is still 32). Is it time to buy more CPUs. For 1.2G, this seems > > a lot of time? Does TAPESIZE parameter has anything to with this ? > > > > maxlen = 140 might not be a bad number for KAIO. My bet would be the > indices. > > John Carlson > Informix DBA > WH Smith, Inc. > > Last seen: at work with a case of 'jet lag' . . . gotta get used to > Eastern Time again. > You might want to consider using ipload -- or high performance loader. We have had success with unloading and loading a 240 million row table as part of a maintenace program every 2 months (defrags) . For smaller tables less than 10 million rows, you could get them unloaded and loaded in a few hours, using device arrays (iploader streams data in parallel to as many 2G disks as you need). We've unloaded and loaded 5 million rows in 1/2 turnaround time -- it's that fast. Problems encountered: fragmented tables with rowids are a problem. fragmented tables without rowids are ok. The gui to set up your projects is not too intuitive, but can learn it very quickly. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum