Is it possible to code the SELECT statement in the code routine? The help documentation is very limited in this area.
Thanks
Server Routine - Custom Build
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Do you mean a "SELECT" to a remoted database (ODBC, or direct DB connect) or to a Hash file?
Since routines tend to get called often, quite frequently once per row of data, doing any type of a SELECT will be extremely slow - considering the enormous overhead involved in connecting and opening up a DB connection.
Since routines tend to get called often, quite frequently once per row of data, doing any type of a SELECT will be extremely slow - considering the enormous overhead involved in connecting and opening up a DB connection.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>