[Koha-patches] [PATCH] Bug 7886 - C4/ShelfBrowser slow SQL performance

[Marc Balmer]

Am 08.04.2012 09:36, schrieb Chris Cormack:
> On 8 April 2012 07:19, Marc Balmer<marc at msys.ch>  wrote:
>>
>
>>
>>
>> bla bla

I whish I had not used these sloppy words here.  It was not my intent to 
insult you in any way, althouth I realize that I did.  It was late, I 
was tired, I read your email whith which I did not agree and completely 
chose the wrong words and did not even explain why I disagreed or offer 
a better solution.  So please accept my apologies for this.

>>
>> using return as a column name is wrong in the first place.
>>
>>
> Rudeness aside, you are correct. However, that does not take away from
> the fact that this is a mySQL specific file, and unless PostgreSQL has
> decided to switch to innodb, will not be able to be used as a schema
> for it. So removing backticks in this file, before changing the column
> names will 1/ Break the file for it's intended use (creating a MySQL
> db for use with Koha) and 2/ Still not be able to be used with
> PostgreSQL
>
> This will be my last exchange with you on this matter, as I find you
> most unpleasant to deal with.
>
> Chris