Support Forum

[rene04]

hi,

what can we do if we want to have more performance for TS? we have to maschines. one ist the TS Server and the other is the database server. our webserver is very fast. would we get more performance if we upgrade our database server. at the moment it is a 1000MHZ with 256MB RAM and we use firebird.

rene

[admin]

hi,

what can we do if we want to have more performance for TS? we have to maschines. one ist the TS Server and the other is the database server. our webserver is very fast. would we get more performance if we upgrade our database server. at the moment it is a 1000MHZ with 256MB RAM and we use firebird.

rene

You can try to move database server to the same computer - it can be very useful. I am also suggest you PostgreSQL over Firebird - it can give you additional 10-30% of perfomance.

[rene04]

database on the same maschine isnt possible because we have access from internet to our TS. so the webserver is in an DMZ and the Database server in our internal network for security! and the database itsself we want not change. so there is no way with upgrading hardware on database server?

rene

[admin]

database on the same maschine isnt possible because we have access from internet to our TS. so the webserver is in an DMZ and the Database server in our internal network for security! and the database itsself we want not change. so there is no way with upgrading hardware on database server?

rene

You can try to upgrade database server, move web server to the database server and create IP tunnel from web server to the database server.

TrackStudio execute a lot of simple queries, so best thing to improve perfomance - reduce single DBMS query overhead.
For example, HSQL (that has almost no query optimization) is the fastest DBMS for TrackStudio, but ORACLE and MS SQL are slowest: they can execute complex queries faster, but for tons of simple queries HSQL win.

[rene04]

what is hsql?
how do i reduce single DBMS query overhead on firebird?

rene

[admin]

what is hsql?
how do i reduce single DBMS query overhead on firebird?

The only way - move it close as close to the web server, as possible.

BTW, what do you mean "slow" ? Please tell me your servers configuration and TrackStudio database size/load.

[admin]

what is hsql?

http://hsqldb.sourceforge.net/

You can try to temporary move your data to HSQL, test it and learn what maximum perfomance you can get changing DBMS and move it to another server. Use "sman" supplied with TrackStudio SA to copy data from Firebird to HSQL.

[rene04]

i dont mean slow. i just want it faster and faster and faster ok. if i cant realize that over upgrading hardware i will let it like it is. perhaps i try hsql sometimes.

thank you

rene