Re: large tables, large keycaches

[Mike Connell]

Interesting possibility. What constitutes an "exact" match with MyISAM?

For example, 2 cases below and associated pseudo code to process it:

<begin

case 1
-------
select token_id, amount from token where account_id = ':variable';
set :variable = '1234', execute, fetch results, and process.

select token_id, amount from token where account_id = ':variable';
set :variable = '5678', execute, fetch results, and process.

case 2
-------
select token_id, amount from token where account_id = '1234';
execute, fetch results, and process.

select token_id, amount from token where account_id = '5678'
execute, fetch results, and process.

end>

in case 1 the JDBC ":variable" is substituted with the value so the statement doesn't have to
be reprepared. I do not think with MyISAM there is savings using case1 vs case2.

Is this a correct understanding?

Thanks