[rt-users] RT Performance, Hardware

[Nate Amsden]

Nate Amsden wrote:
> 
> Manfred Hui said:
> > By the way, please backup your data before playing with the
> > indexes.
> >
> 
> excellent! thanks! i'll see if i can try this today, i have
> a 2nd rt installation thats on another DB server i can experiment
> on with semi-recent data from the first installation.


i ran a couple crude tests with this one ticket that takes a while,
results are without the indexes, takes 45 seconds to load, with the
indexes it takes 16 seconds to load. much improved!! in addition,
the system with the indexes isn't even running mysql locally, its
going accross a 100baseT network via SSL. so that adds some latency
to the connection, still almost 3 times faster then the one running
mysql locally(through sockets even)

and if anyone else is reading this thread for hints, i manually executed
the SQL strings one by one instead of importing the whole file, mysql
complained about things already existing when i tried to load the whole
file.

thanks again

nate


-- 
Nate Amsden
System Administrator
GraphOn
http://www.graphon.com