> On Mon, 4 Dec 2006, Gerhard Hofmann wrote: > > > > Gerhard Hofmann wrote: > > > Hi all, > > > > > > it seems that Ingres 2006 is very slow when reloading a database. > > > > > > Example: a database is unloaded, unload takes about 5 minutes and > > > consumes about 1.6 GigaBytes of disk space -> quite good unload > > > performance. The same database will take over an hour (!) to reload on > > > the same PC. > > > > > > Is this a known issue? Any workaround for this? > > > > > > I have seen this problem on three PCs now (two were Win XP Pro, one was > > > Win 2003 Server). I definitely haven't experienced this with 2.5 / 2.6 / > > > 3.0.3. > > > > > > > Hi, > > > > I'd like to "restart" this old thread. Some of you supposed that the > > different reload times between 3.0.3 were caused by different hardware, > > different disk layout, weird CBF settings and so on.
It just occurred to me: Ensure there are no indicies on your tables as you reload and then recreate the indicies after the load is complete. The time it takes to continually add pages to an index can be vastly longer than creating a new index as the data set size is known in advance... Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ _______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
