The discision to move from M$ Access to SQL Server of Oracle usally is not
dependant on the number of records, but rather on the number of concurrent
users.
I have worked with M$ Access datasets of 300 000+ with no problem. THere is
a big jump from M$ Access to corporate servers such as SQL Server. If a lot
of read-writes are needed and you have 5+ users then it might be worth it.
If it is only read access we have a sight where one MapInfo table hold 300
000+ records and is accessed by 80+ users with no problem.
If you would like more help reply with more info of the setup.
Yours
Anton de Gruchy
------------------------
MapIT - Maps & IT
email : [EMAIL PROTECTED]
cell : 082 855 9747
tel : 548998
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Yoshiro Nagao
Sent: Sunday, January 10, 1999 15:11
To: [EMAIL PROTECTED]
Subject: MI MS SQL Server or SpatialWare or...
Hello,
I have a very large dataset, too big
to be stored in Microsoft Access.
So it might be too big also to be
stored as Mapinfo table.
As I want to map the above dataset
on MI professional, I was considering
MS SQL Server6.5.
> From the past postings to this mailing list, though,
ODBC seems unstable, or in other word,
difficult to tune up.
Are there any other RDB product whose connection
to and from Mapinfo/MapBasic is
100% guaranteed by Mapinfo corp.?
Which RDB has the best affinity with Mapinfo?
SpatialWare is the one?
Are there student/academic price for it(Thailand price)?
Which of Oracle product on NT4.0 Server is
cheapest and compatible with it?
And if you have any experience(trouble/satisfaction) with
it, please let me know it.
Yoshiro Nagao
8-13 Egamicho, Nishinomiya
6620855 Japan
FAX: +81-798-22-0678
mobile phone: 090-8874-6235
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
