How do you run an event procedure on the server?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large table on an SQL Server 2000. I have an update form on the Client populated with data from that table. I have an involved Find event procedure (activated with a button on the form) which is to repopulate the form with the data of the matching record. When I use a link to the server table, the Find routine is very slow. While I know how to run queries on the server (and even pass-through queries), this Find procedure does not lend itself well to translation into a query. What is the best way to have the actual searching done on the server so as to speed up the process

Thanks.
 
Hi,

Just wondering if you have your index (or indices) included in your
pass-through SQL call along with a good / fast filtering tool like the In
clause (not the Where clause)?

--
Calvin Smith
http://www.CalvinSmithSoftware.com - Automation Code
http://www.SpanglesNY.com - Fendi, Prada, Von Dutch, etc - 60% off


Betacon said:
I have a large table on an SQL Server 2000. I have an update form on the
Click to expand...
Client populated with data from that table. I have an involved Find event
procedure (activated with a button on the form) which is to repopulate the
form with the data of the matching record. When I use a link to the server
table, the Find routine is very slow. While I know how to run queries on the
server (and even pass-through queries), this Find procedure does not lend
itself well to translation into a query. What is the best way to have the
actual searching done on the server so as to speed up the process?
 
Back
Top