Mailing List Archive


Back to the month index Back to the list index
Alex (A.C.G.Smith@newcastle.ac.uk)
Fri, 21 Nov 1997 10:40:53 GMT0BST 

From: "Alex" <A.C.G.Smith@newcastle.ac.uk>
Date: Fri, 21 Nov 1997 10:40:53 GMT0BST
Subject: (msql -l) documentation for msql
Message-ID: <6DC0D484742@TOWN7.ncl.ac.uk>

Good morning,

I am a student looking to use msql alongside ArcView GIS
for my final year project, and I need documentation for msql.
Could someone please point me in the right direction? I've
tried http://AusWeb.com.au/computer/Hughes but have
been unable to get through.

Handy hints on using msql alongside ArcView would also be much
appreciated if anyone has any experience of this.

Thanks
Alex
From A.C.G.Smith@newcastle.ac.uk Fri Nov 21 06:09:11 1997
Received: from cheviot.ncl.ac.uk (cheviot.ncl.ac.uk [128.240.233.51])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id GAA08795
        for <msql-list@services.bunyip.com>; Fri, 21 Nov 1997 06:09:06 -0500 (EST)
Received: from TOWN7.ncl.ac.uk by cheviot.ncl.ac.uk id <LAA20333@cheviot.ncl.ac.uk>
  (8.7.6/ for ncl.ac.uk) with ESMTP; Fri, 21 Nov 1997 11:09:04 GMT
Received: from TOWN7/SpoolDir by TOWN7.ncl.ac.uk (Mercury 1.21);
    21 Nov 97 11:09:05 GMT0BST
Received: from SpoolDir by TOWN7 (Mercury 1.30); 21 Nov 97 11:08:44 GMT0BST
From: "Alex" <A.C.G.Smith@newcastle.ac.uk>
To: msql-list@services.bunyip.com
Date: Fri, 21 Nov 1997 11:08:35 GMT0BST
Subject: Re: (msql -l) documentation for msql
Priority: normal
References: <6DC0D484742@TOWN7.ncl.ac.uk>
In-reply-to: <56F87EB1CD7@reze-1.rz.rwth-aachen.de>
X-mailer: Pegasus Mail for Windows (v2.53/R1)
Message-ID: <6DC83F75837@TOWN7.ncl.ac.uk>

Two addresses I've been given for documentation:

http://www.hughes.com.au

http://www.cs.umbc.edu/~finin/461/msql (an excellent looking
tutorial)

Alex
From yuq-msql@wayx.com Fri Nov 21 08:17:22 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id IAA10110
        for <msql-list@services.bunyip.com>; Fri, 21 Nov 1997 08:17:21 -0500 (EST)
From: yuq-msql@wayx.com
Received: from ns.wayx.com (ns.wayx.com [151.196.88.44])
        by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id IAA03048
        for <msql-list@Bunyip.Com>; Fri, 21 Nov 1997 08:17:19 -0500 (EST)
Received: from yuqiang.wayx.com (dailuser.gb.com.cn [203.93.18.160]) by ns.wayx.com (8.8.5/8.6.12) with SMTP id VAA17198 for <msql-list@Bunyip.Com>; Fri, 21 Nov 1997 21:17:51 +0800 (CST)
Message-Id: <3.0.32.19971121211605.006862e0@marcus>
X-Sender: yuq-msql#X-Sender: yuq-msql#wayx.com@marcus (Unverified)
X-Mailer: Windows Eudora Pro Version 3.0 (32)
Date: Fri, 21 Nov 1997 21:16:52 +0800
To: msql-list@Bunyip.Com
Subject: S.O.S. H~~E~~L~~P!!!
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

hi,all

  I need your HELP.Please DO give some attention,Especially those MiniSQL
experts and guys from Hughes.

  My question is about the index of minisql 2.02.I found the index file
size is something fixed.What I mean is no matter how many rows I have in a
table,the index file's size is the same.

I have such a table:
create table table1
(
yunit char(38),
yleader char(20),
ypostcode char(6),
ytelcode char(5),
ytelnumber char(14),
yaddress char(58),
yservice char(20),
yclasscode char(4),
yareacode char(6),
yusercode char(7),
ypasswd char(8),
yexpire char(10),
yreserve1 char(4),
yreserve2 char(4)
)

and create a index by such statement:
create index idx_yunit on table1 ;

After inserting only ONE record into the table by msqlimport,I got the
following list by ls -l:

-rw------- 1 nobody other 14369 Nov 21 20:57 table1.dat
-rw------- 1 nobody other 2184 Nov 21 20:34 table1.def
-rw------- 1 nobody other 288 Nov 21 20:58 table1.idx
-rw------- 1 nobody other 1146912 Nov 21 20:58 table1.idx-
                                        ^^^^^^^
idx_yunit
-rw------- 1 nobody other 4 Nov 21 20:34 table1.ofl

WHY?Why the idex file size is so large?I only have one record at all.

May be you will say that the strategy of Hughes.But now,I have about 991
tables with same structure as above.I divide them into so many tables only
for geting faster query speed.The total data are may be 300MB,I think I can
hold all the tables within 500MB,but if a table with only one record will
have a 1MB index file,how about 991 tables?

I have promise my customer that I can hold them in about 500MB.What should
I do now?Should I run query without index?
Any one can give me some solutions or explanations?Are there some one from
Hughes?

I don't know what will happend if I can not hold all tables in about
500MB.I don't know what my customer will do.So,Please Do help me.

Thank you a lot.
any help plese mail to any help plese mail to yuq-msql@wayx.com.