How to update multiple entities (1000) in jmix

Support
#1

How can i update multiple entities in jmix. In cuba i was using entity manage and query. Do i have to use for loop only or any another way?

#2

The most native to Jmix way to manipulate entities is DataManager. When you use it, you can be sure all Jmix features work properly: access control, entity events, audit.

You can pass all your entities at once to save them in one transaction, see the docs.

For example:

dataManager.save(customer1, customer2, order1);

List<Customer> customers = Arrays.asList(customer1, customer2);
dataManager.save(new SaveContext().saving(customers, order1));

If your collection of entities is too large, split it to chunks and use a loop to save in separate calls to DataManager.

#3

Thats exactly I am doing presently using ‘for loop’, but whether it will affect performance or server load. In cuba running native sql queries was fast for even 10000 records (my experience)

Whether down the line we will be able to run native sql in jmix?

Thanks

#4

Sure you can run native queries in Jmix.

Use EntityManager or Spring’s JdbcTemplate, for example:

    @Autowired
    private DataSource dataSource;
    
    public void executeSql() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        // ...

See also this hint for improving performance of data saving: DataManager save function's effeciency too low

1 Like
#5

Truely helpful Jdbc is, but using too much Jdbc in a project makes code kind of unsustainable :joy:

#6

If you want to use DataManager for saving lots of data, see these recommendations in the docs: Save Performance.