* Niral Trivedi ([EMAIL PROTECTED]) [010515 15:22]:
> You are right Stephen,
>
> But we have our db on a different host. And that'swhy we need to connect
> using IP and not localhost.
>
> What my point was, if that creates a performance issue, then we might have
> to host the db on the same box as our application and we'll use localhost
> instead of IP.. But before we do that, I want to make sure..
>
> I am trying to find some documentation on the net. Found so many threads
> regarding DBD::ODBC performance but that didn't help me..
>
> also looked in 'Programming the Perl DBI' book but no luck..
This is a frequent topic in the mod_perl arena. See:
http://perl.apache.org/guide/strategy.html#When_One_Machine_is_not_Enough_f
Summary (IIRC): unless you're communicating using LocalTalk, it's
usually a good thing to move your DB to a separate machine.
Chris
--
Chris Winters ([EMAIL PROTECTED])
Building enterprise-capable snack solutions since 1988.
