Hello Joao, aside from the problems due to the DNS lookup of the client address at the server, have you compared the systems regarding general disk i/o performance?
You may want to run a filesystem benchmark (I suggest the traditional 'Unix bonnie filesystem benchmark' available e.g here http://www.textuality.com/bonnie/download.html ), and keep in mind that NTFS is somewhat slower than ext2/ext3 or even raw devices in Linux. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: news [mailto:[EMAIL PROTECTED] Behalf Of Joao > Sent: Friday, February 06, 2004 2:27 PM > To: [EMAIL PROTECTED] > Subject: Re: Fast Fedora, Slow AIX ? understandable... > > > hi, > Yes Bogdan... I did that also... no efect... > > But have this influence in Inserts ? > > Regards, > Jo�o Rodrigues > > "Bogdan Ene-Iordache" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] > Did you try to append the right lines in the various "hosts" files ? > > Bogdan > > > Tanks Marcin for fast reply, > > But my major problem is the time it spends to fill the 30000 > > records... connection time is one problem but isnt the > major problem. > > Otherwise I have disabled the DSN in all network... and the > connection > > time didnt change. > > > > Regards, > > Joao Rodrigues > > > > "Marcin P" <[EMAIL PROTECTED]> escreveu na mensagem > > news:[EMAIL PROTECTED] > > > Looks like DNS issue, doesn't it? > > > Search in archives how to solve the problem with long > > > connecting times... > > > Regards, > > > Marcin > > > > > > U�ytkownik "Joao" <[EMAIL PROTECTED]> napisa� w wiadomo�ci > > > news:[EMAIL PROTECTED] > > > > Hello, > > > > > > > > I Have a big problem > > > > > > > > I Have a AIX system in IBM Risc System 6000... > > > > 450 Mhz > > > > 512 Mb Ram > > > > SCSI disks > > > > 100 mbps Lan connection > > > > > > > > When I try to connect to the system (using the IP address ) it > > > > takes a > > lot > > > > to establish the connection. > > > > > > > > Then I Have a procedure that fills some tables with about 30000 > > records... > > > > this procedure takes about 2 hours in that system. > > > > > > > > Another system: > > > > Windows Server 2003 > > > > 2xPentium 4 3.0 Ghz > > > > 2Gb Ram > > > > SCSI disks > > > > 100mbps Lan Connection > > > > > > > > In these one, the connection is established fast but > takes +/- the > > > > same > > > time > > > > performing the fill of tables ... +/- 2 hours... > > > > > > > > > > > > > > > > But, > > > > I Have another machine , an older one, running the same > version of > > SAPDB, > > > > but with linux (Fedora Core 1 ): > > > > Pentium II 600 > > > > 256 Mb Ram > > > > IDE 5400rpm 10Gb disk > > > > 100 mbps connection > > > > > > > > And in this machine i conect fast, and takes about 10 minutes to > > > > preform > > > the > > > > filling of tables... > > > > > > > > What i've did wrong ???? > > > > > > > > (Note : SAPDB 7.4.3) > > > > > > > > Tanks, > > > > Jo�o Rodrigues > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > MaxDB Discussion Mailing List > > > > For list archives: http://lists.mysql.com/maxdb > > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > -- > > > MaxDB Discussion Mailing List > > > For list archives: http://lists.mysql.com/maxdb > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
