Hi Martin, > I started using OO Base with ODBC and MySQL. It was slow to the point of > being unusable, and I almost gave up. However, I found that if I use the > IP address of the database server rather than the hostname, things go much > faster. > > What I did was edit the /etc/odbc.ini and put the IP for the Server field, > like this: > > [MySQL-test] > Description = MySQL database test > Driver = MySQL > Server = 10.16.5.37 > Database = test > Port = 3306 > > In case someone else has the same problem, they can try this. If I was > using DHCP, I would not know how to solve it, so it'd be nice if a > developer could shed some light on this problem.
Would be interesting to know whether the performance problem also happens with applications other than OOo. All which OOo sees from your configuration is "MySQL-test", that's the logical name used by OOo to connect to the data source. Everything else - including the Server setting - is under the control of the ODBC/driver manager, and not of OOo's concern. So, it doesn't really sound as if this is an OOo problem. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
