FE/BE runtime speed

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

Guest

Hi guys,

I have a FE application with one BE table w/ only about 23K records. It
takes about 8 to 10 second from when I click on a form's combo boxes using a
simple query to load the results of that query in that box. When I had the
table on FE it was instantaneous.

My question is, is there a way with code to speed up the connection or is
that just how long it takes b/c it has to find the server and whatnot????
 
Retrieving data across a network is slower than retrieving it from the local
hard disk, but there may still be ways to improve the performance. Restrict
the number of rows and columns returned if you can, avoid complex
expressions, and make sure any fields used in sorting, filtering, or joins
are indexed. If you post the SQL for the record source of the combo box,
someone may be able to offer more specific suggestions.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top