home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #31 / NN_1992_31.iso / spool / comp / database / 8666 < prev    next >
Encoding:
Text File  |  1992-12-23  |  806 b   |  25 lines
  1. Newsgroups: comp.databases
  2. Path: sparky!uunet!cs.utexas.edu!sun-barr!ames!pacbell.com!att-out!cbfsb!cbnewsg.cb.att.com!nh
  3. From: nh@cbnewsg.cb.att.com (nicholas.hounsome)
  4. Subject: Informix Performance Tips Query
  5. Message-ID: <1992Dec23.084442.16657@cbfsb.cb.att.com>
  6. Sender: news@cbfsb.cb.att.com
  7. Organization: AT&T
  8. Date: Wed, 23 Dec 1992 08:44:42 GMT
  9. Lines: 14
  10.  
  11. Has anybody got any tips on how to get the best performance out
  12. of informix (online) ESQL?
  13.  
  14. The database is about 10M with the largest table being about 
  15. 20K rows.
  16.  
  17. Increasing the cache size seems like a good idea. I have tried a lot
  18. of other stuff that they recommend and it doesn't seem to make much
  19. difference (eg. extent sizes).
  20.  
  21. How nuch difference does preparing statements make compared to
  22. statements fully parsed by esql?
  23.  
  24. Nick Hounsome
  25.