db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Auinger, Thomas" <Thomas.Auin...@wincor-nixdorf.com>
Subject AW: Strange values in id table
Date Wed, 04 Jun 2003 09:06:09 GMT
Did you notice, that if you divide
NEXT_ID through QUANTITY it results always
in something like 23?

I don't mean to make any relation to the
famous German movie '23' :)) but seems to be
some higher precaching or something??


Cheers,
 Thomas



> -----Urspr√ľngliche Nachricht-----
> Von: svallet [mailto:svallet@t-systems.fr]
> Gesendet: Mittwoch, 4. Juni 2003 11:02
> An: Turbine Torque Users List
> Betreff: Strange values in id table
> 
> 
> 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
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 

Mime
View raw message