if you want speed then why use a MicroSlow database system? It's quite likely that MS SQL is chewing up so many resources on the server (just being there) that any additional work puts a stress on the server machine. If you can switch to a lightweight/fast DB server like mysql, then you can use whatever (ODBC/DBI) and see it fly. MS SQL server, Oracle and some other elephants are only meant for databases with needs like: automatic referential integrity checking/cascading, stored procedures, db scaling to several servers. I've seen these elephants used in situations where MS Access or DBase should have been used instead. So if you don't need an elephant, get a gazelle :) Chris Chris

In reply to Re: SQL Server ODBC by aquarium
in thread SQL Server ODBC by hakkr

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.