Dear Thomas and Noel,
We are using linked table function with a postgres database.
We have some performance issues with a delete statement from H2.
We use :
DROP TABLE IF EXISTS finalusr;
CREATE LINKED TABLE finalusr ('org.orbisgis.postgis_jts.Driver',
'jdbc:postgresql_h2://...', '...', '...', 'myschema', 'mytable');
DELETE FROM finalusr WHERE code_insee = '56260';
--> Takes 10 minutes
The same query on the postgresql server side
DELETE FROM myschema.mytable WHERE code_insee = '56260';
--> Takes 62 msec
Thanks in advance to any input.
Erwan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
