For some reason our getChar function, which returns the character searched for, includes a 10 second delay on returning the character!
This is particularly bizarre given that getAllChars returns an array of all characters in no time at al, and when we run the same command in psql/pgcli in the terminal, the delay doesn't happen!
For some reason our getChar function, which returns the character searched for, includes a 10 second delay on returning the character!
This is particularly bizarre given that getAllChars returns an array of all characters in no time at al, and when we run the same command in psql/pgcli in the terminal, the delay doesn't happen!
The SQL query in question: