yjkim@milton.acs.washington.edu (Yong Kim) (01/15/90)
I have a problem in running Ingres in my AT. My machine has 1.5 M of extended memory above 1M base memory. I used EMS driver to use 180K of base memory and 700K of extended memory as ExPanded memory because with a few drivers on the system, some feature of Ingres refused to run. My question is: (1) I would like to know how I can import raw data (in ASCII format, possibly single quote is allowed). Is there such a utility in Ingres? (2) It looks like their interpretation of SQL language is SLOW. I happen to believe that because all SQL queries are translated into QBF's before they are executed. Is this true? It took around 1 min to insert 30 records into a table. (3) After inserting 29 records, Ingres/ISQL gave me "query buffer full, some characters are lost" (or similar to this) warning message. How can I solve this problem. I tried addingres -D64000 -Q30000 without much success. The magical number 64000 seems to me that query buffer or dynamic memory are limited one segment chunk of 8086 architecture. If this is true, can Ingres handle a large database in my AT? For an instance, 4000 records of 80 bytes long? I am in need of any information desperately since I spent 2 days to avoid these problems. Thanks in advance!