Forum OpenACS Q&A: Object creation speed

Collapse
1: Object creation speed
Posted by Gabriel Burca on 12/05/03 05:13 AM
I need to create some 30,000 pre-defined objects on installing a package. It is currently taking about 7 minutes to do that. Any suggestions on how I can speed it up? Is there a way to create objects in "bulk"?

For test purposes I moved all the acs_object__new code inline and removed my own code so the only thing being done inside the loop is a call to acs_object_id_seq.nextval, the "insert into acs_objects", and the "PERFORM acs_object__initialize_attribute". It's still taking way too long.

Collapse
2: Re: Object creation speed (response to 1)
Posted by Caroline Meeks on 12/05/03 05:37 AM
What version of OACS are you using? PG or Oracle?

If you are on 4.6.3 there are some 5.0 performance improvements you can try applying. See this thread.

https://openacs.org/forums/message-view?message_id=143978

Collapse
3: Re: Object creation speed (response to 2)
Posted by Gabriel Burca on 12/05/03 05:41 AM
I'm testing using one of the latest 5.0 versions of OACS, with PG 7.3.3.