Some remarks + questions... 2005/11/2, Heckendorff. Ronald <[EMAIL PROTECTED]>: > Hi Martin, > I now need 2 minutes to restore my test scenario. I just checked Oracle and > Ms-Sql Server. It is the same computer. Oracle is running on Linux and MaxDB > and Sql Server are running on w2k pro. > > 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? > 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#addBatch() > The loader is no option for us. We need to have the file that holds the > backup on the client and not on the server. The loader needs the data always > on the server. So this is not practicable for us. That's not exactly true: you need the date where the loader is installed. Should be no problem to install the loader on your client machine. That's why SQL Server and Oracle have a client utils installer. > We also don't want to implement a solution only for one dbms. We have to > support more then maxdb. Of course it's easier with JDBC then. Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
