hi
sorry for my ignorance, but as I’m like fellow list-members in planning the move
from 3.0.9 to 3.2.1 here I’m once again in testing how long a whole insert of
our rt-database into a new database takes (yes, I have to do it the “right” way
for replication to work and other stuff). and the result is mysqldump is pretty
fast - but the inserting is something I should plan for at least a weekend
(and always thought we had fast boxes g).
just for the goof I also tested this export+import thing using myisam tables and
(surprise surprise) that got it a lot faster
now - I don’t see relationships between the tables (references) and I deeply
believe rt v2 was running on myisam tables - now I really tried to find a
reference on “why innodb” or at least some transactional code in the sources,
but couldn’t find any (but hey, that’s me - not a specialst).
so my dumb question here: are innodb-tables necessary? (and why?)
thank you in advance
Harald Kapper, icq# 36178328 kapper.net, inc.
managing director, owner, loeblichgasse 6
chief executive officer 1090 vienna, .at
tel +43 1 3195500-0, fax +43 1 3195502, hk@kapper.net
--------------quote.of.the.day--------------
All programmers are optimists
– Frederick P. Brooks, Jr.
hi
still planning migration
(but already had some successfull runs from 309 to 321 and yet kept the
TemplateList from RT v2 :-o)
now to the performance-question - I tried to find out, but basically couldn’t
get a hold on whether fastcgi or mod_perl would bring a bigger speed up on
RTv321.