2005/11/3, Heckendorff. Ronald <[EMAIL PROTECTED]>: > > > For restoring the same backup date from an identical client to > nearly > > identical network server I got: > > > MaxDB: 2 minutes > > > Oracle: 30 seconds > > > Sql-Server: 40 seconds > > > > How did Oracle manage to beat SQL Server? Just curious because for us > > Oracle is always slower. Or do you have significant differing > > hardware? Also, do you use jTDS or Microsoft's JDBC driver? > > It was the first time that I saw that Oracle is faster then sql server. > Maybe a new test will show a slightly different result. I didn't check > this in depth. I gathered the results only for getting a first > impression.
Ah. You seem similarly surprised as me. :-) If you learn something new about this I'd be interested to hear it. > > > In comparison to oracle this is a ratio of 1:4 (30 seconds : 2 > minutes). > > This is acceptable for us. > > > > > > I now still use the jdbc solution with prepared insert statements. > Maybe > > we'll try the batch update but not sure if this will speed up the > restore > > too much. > > > > You can use batch updates with PreparedStatement: > > > http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedStatement.html# > ad > > dBatch() > > > > > Well I know how to use batch updates. During the last weeks I tried to > solve my problem with this too. But it didn't show significant > differences in comparison to inserts with a prepared statement. But > maybe this was cause by the stupid trigger that we used before. > Alexander also told me that it is faster, but anyway, at the moment that > has no priority for me. Other tasks are more important then this. No offense intended. But from your answer I'm not sure whether you actually used or are aware of the combination of PreparedSatement and batches. Note that addBatch() of PS doesn't take an argument. Just wanted to make sure that this option doesn't go unnoticed. > I increased the performance for maxdb from 2 hours to 4 minutes, wow ;-) That's what I call "effective optimization". :-) Cheers robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
