Re: Network Efficiency

perryche@xxxxxxxxx wrote in
news:1153273248.329538.143490@xxxxxxxxxxxxxxxxxxxxxxxxxxx:

I know having a better network (faster), increasing RAM, goto SQL
server... are not options for me at my work. It will take much
more than what I am able to change there. Therefore, the only
options I have are: split the DB to FE and BE, Break up Table to
smaller ones, Use VB codes that have an error handler, what else?

The main thing is to request and load only the smallest data set
that can satisfy a user's needs. That means for regular forms, one
record at a time, for continuous forms as subforms, only the records
belonging to the parent record, for combo- and listboxes, fewer than
100 records, with rowsource assigned only after a couple of
keystrokes are typed when you have more than 100 or so records in
the table it's based on.

That's just for starters. The main thing is:

Never bind anything with a recordsource/rowsource to a full table --
always filter to the smallest dataset possible.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • X locks up after a random time
    ... KDE desktop, compiz and all, but I believe it is not ... system boots up regularly, I do regular work, and after a random ... The server is probably stuck in an infinite loop. ...
    (Fedora)
  • Re: FTP to z/OS Problem
    ... The search order for the file FTP DATA is given in Table 3, ... configuration data sets" in a section of the same name under "Configuration ... Communications Server IP Configuration Guide as follows: ... The MVS data set or z/OS UNIX file specified on the SYSFTPD DD ...
    (bit.listserv.ibm-main)
  • Re: OT .. Road Warrior communications question
    ... Should I be able to always connect to my regular internet host/email ... Is that a firewall issue with the hotel providing the connection? ... outgoing mail server. ... the point where I use Google's gmail more and more, ...
    (alt.guitar.bass)
  • Re: z/OSs basis for TCP/IP
    ... direction in the IP component of z/OS Communications Server is to get rid ... The Pascal socket interface uses the IUCV/VMCF services for a limited set ... TSO HOMETEST, LPQ, LPR, LPRM, LPRSET, TELNET, and TESTSITE commands ... - that the generically named TCPIP.DATA data set HOSTNAME ...
    (bit.listserv.ibm-main)
  • Re: she can of course happen in search of irish overwhelming toilets
    ... I satisfy already, unless Samuel wonders ... teams amid Moammar's server. ...
    (sci.crypt)