<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<br>
<br>
RC2 is running in production without any apparent problems<br>
till now. Well its difficult to say at the moment how much speed<br>
gain is there unless the heavy duty batch SQL scripts are run by<br>
cron. <br>
<br>
Count(*) and group by on large tables are significantly (5x) faster<br>
and better error reporting has made it easier to spot the faulty data.<br>
eg in fkey violation.<br>
<br>
Will post the OSDB .15 versions' results on 7.3 & 7.4 soon.<br>
<br>
Regds<br>
Mallah.<br>
<br>
Christopher Browne wrote:<br>
<blockquote type="cite" cite="midm34qxau6bb(dot)fsf(at)wolfe(dot)cbbrowne(dot)com">
<pre wrap="">After a long battle with technology,<a class="moz-txt-link-abbreviated" href="mailto:mallah(at)trade-india(dot)com">mallah(at)trade-india(dot)com</a> (Rajesh Kumar Mallah), an earthling, wrote:
</pre>
<blockquote type="cite">
<pre wrap="">the error mentioned in first email has been overcome
by running osdb on the same machine hosting the DB server.
</pre>
</blockquote>
<pre wrap=""><!---->
Yes, it seems unrealistic to try to run the "client" on a separate
host from the database.
I got the osdb benchmark running last week, and had to separate client
from server. I had to jump through a fair number of hoops including
copying data files over to the server. The benchmark software needs a
bit more work...
</pre>
</blockquote>
<br>
</body>
</html>