Forum OpenACS Q&A: Object creation speed

Collapse
Posted by Gabriel Burca on
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
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
I'm testing using one of the latest 5.0 versions of OACS, with PG 7.3.3.