RE: Performance with quoteSqlIdentifiers

2021-11-23 Thread Meeks, Andrew
That's great to know! Thank you for the quick response. -Original Message- From: Andrus Adamchik Sent: Tuesday, November 23, 2021 10:24 AM To: user@cayenne.apache.org Subject: Re: Performance with quoteSqlIdentifiers Hi Andrew, DataMaps don't work as "layers" on t

Re: Performance with quoteSqlIdentifiers

2021-11-23 Thread Andrus Adamchik
Hi Andrew, DataMaps don't work as "layers" on top of each other, so the answer to #2 is no. For #1, I am not aware of any visible performance impact of quoting identifiers. So you can just use quoted identifiers everywhere. Andrus > On Nov 23, 2021, at 5:16 PM, Meeks, Andrew wrote: > > Hell

Performance with quoteSqlIdentifiers

2021-11-23 Thread Meeks, Andrew
Hello, My production database is Oracle but I do local testing with in-memory H2. I have been using two datamaps; "src/main/resources/datamap.map.xml", and "src/test/resources/datamap.map.xml". When I make an ORM change and it's been a year or two, I eventually remember to copy the datamap fr