db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "svallet" <sval...@t-systems.fr>
Subject Strange values in id table
Date Wed, 04 Jun 2003 09:02:21 GMT
Hi !

I'm using the id broker feature of Torque ; by looking closer at the id
table, I get (what seems to me) very strange results :

mysql> select * from id_table;
+-------------+-----------------+---------+----------+
| ID_TABLE_ID | TABLE_NAME      | NEXT_ID | QUANTITY |
+-------------+-----------------+---------+----------+
|           1 | ID_TABLE        |   16558 |      713 |
|           2 | TYPE_ENTREE     |   14251 |      610 |
|           3 | ATTRIBUT        |   51901 |     2250 |
|           4 | DICTIONNAIRE    |       1 |       10 |
|           5 | NOM_ATTRIBUT    |       1 |       10 |
|           6 | NOM_TYPE_ENTREE |       1 |       10 |
|           7 | LANGUE          |       3 |       10 |
|           8 | ADOPTION        |      61 |       10 |
|          29 | SIMON           |      31 |       10 |
|          89 | T_TEST2         |       1 |       10 |
|         139 | T_HELLO         |     201 |       10 |
|       15132 | T_CUSTOM        |       1 |        5 |
+-------------+-----------------+---------+----------+
12 rows in set (0.24 sec)

How does it come that Quantity values are so high (2250) ??
my settings are the following (I use torque directly from API) :

[some settings]
torqueProps.addProperty("torque.idbroker.cleverquantity", "true");
//torqueProps.addProperty("torque.idbroker.prefetch", "false");
//torqueProps.addProperty("torque.idbroker.usenewconnection", "false");
Torque.init(torqueProps);

Trying to set "torque.idbroker.prefetch=false" did reset some "Next_id"
values to 1, and not some others... so I commented it out ;
"usenewconnection" has alwas been uncommented

I initialize the id table manually with Quantity values of 10 (the last
table is a test case) -> I would _love_ to get Torque to initialize it, but
didn't got it right :( (but things seem to work, apart from this)

Thanks for any suggestions,
Simon

--
Simon Vallet
T-Systems e-technologies
svallet@t-systems.fr


Mime
View raw message