Using TDK 2.1, mysql -- I've got a couple of forms on my site which have a number of entries in them; when they are submitted, those entries are all inserted into a table in the database which uses the idbroker mechanism in torque for generating unique IDs. However, due to the size of these forms, I often get a 'Unscheduled Retrieval of primary keys on table xxx' message. I also have:
database.idbroker.cleverquantity=true such that the QUANTITY value for this table in the ID_TABLE is automatically increased. Torque seems to be calculating a 'rate' at which these IDs are requested, and since these all come in at once from a form submission, it bounces the QUANTITY value from 10 to around 7000. It also seems as if there's a timeout on the usage of those IDs (not sure about this), in which case since my form is in the 30-40 range, chances are I'm going to be wasting quite a few IDs as they are retrieved from the database. Is there a way to configure the default QUANTITY value in the ID_TABLE so the usage is a little more efficient? Or is the solution to manually update the ID_TABLE.QUANTITY following an 'ant init' to a more reasonable value (like 100)? Or is it moot based on how the cleverquantity mechanism works? Thanks, Derek -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
