Hello everybody, I found that using .like() method with Postgresql actually perform a case insensitive search (it uses ILIKE not LIKE). I read an old thread stating that this is for compatibility issues with mySql. I have a very big table with text field in upper-case so I don't need ILIKE but any searche with .like() takes at least 8 time longer than it should with LIKE. Obviously I can change the ILIKE with LIKE in dal.py code to make it works or make a custom SELECT with .executlsql(). But would be possible to add an optional parameter in the .like() method to choose case-sensitive search (something like casesensitive=True)? This would not break compatibility or portability because the default would remain case-insensitive.
Bye, Giovanni