ProC like with VARCHAR is extremely slow in V7

Just when I have accepted the fact that my ProC executables will be 1Mb bigger under ProC 1.5.1, along comes another problem. I have a SQL statement which runs fine against our V6.033 database buts is extremely slow against our V7.016 database. After trying all kinds of permutations, it comes down to this: The following is very slow:

	EXEC SQL SELECT ACOLUMN
	INTO :an_int
	FROM ATABLE
	WHERE ANOTHER_COLUMN LIKE :a_varchar;

This runs at a reasonable speed:

	EXEC SQL SELECT ACOLUMN
	INTO :an_int
	FROM ATABLE
	WHERE ANOTHER_COLUMN LIKE 'FOO%';

For some reason, the varchar slows things right down. I don't know why, because it should be mapped into the 'FOO%' string before the query is sent to the database. And I don't know why this problem exists in 7.016 when the same code runs fine in 6.033.

Does anyone know what is going on? A workaround/bug fix would be really nice now.

rob allan
email: rob.e.allan_at_hydro.on.ca Received on Fri May 27 1994 - 22:26:18 CEST