Avatar

Level 2

Hello!

I am currently using a SQLAssembler to read and write to an Oracle database. When my Flex application loads, I call a fill method to get a list of customers. This list of customers is about 9000 so it take a little bit of time to load initially. The customers are loaded into an arraycollection and that arraycollection is passed to a datagrid for displaying. After the data appears in the data grid, a user can create a new customer. The new customer is added to the arraycollection:

customerCollection.addItem(newCustomer);

Using the additem on the arraycollection calls the create-item sql in the sqlassembler which is just an insert statement. Since the arraycollection has 9000+ customers in it, it takes a long time for the new customer to be added to the database. Is there a way to speed this up? Please let me know if I am missing any information that may be useful.

Brenda