I agree with David. While it has been a while since I used Minisoft ODBC I
think it was quite efficient. I used ODBC/se for a while and I remember that
sometimes it would use a serial read instead of a chained read, and on a
data set with over 2 million records it would take forever. I would double
check what way the data is being accessed. If I remember correctly Minisoft
was very flexible and could be configured to help solve the problem.
Gary Nolan
----- Original Message -----
From: "David T Darnell" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Monday, February 11, 2002 12:42 PM
Subject: Re: [HP3000-L] Q: odbc, linux, mysql, replicate
> I must say "whoa! hold on!" IMO Jonny does not "need" ADBC for speedy
> access to his Image data.
>
> If his retrievals are slow using Minisoft's ODBC, he is either retrieving
a
> very large volume of data, or as suggested in a previous reply on this
> thread, does not have his Image or Omnidex indexes optimized for the types
> of queries he is doing. Yes, Minisoft's product handles Omnidex. I fail
to
> see how investing in ADBC is going to solve this type of problem, even if
> ADBC would work as well or a little better than ODBC/32.
>
> I believe Mr. Thatcher is being a little over agressive in his marketing
of
> ADBC.
>
> -Dave Darnell
>
>
>
>
>
>
> David Thatcher <[log in to unmask]>@RAVEN.UTC.EDU> on 02/11/2002
> 05:30:32 AM
>
> Please respond to [log in to unmask]
>
> Sent by: HP-3000 Systems Discussion <[log in to unmask]>
>
>
> To: [log in to unmask]
> cc:
> Subject: Re: [HP3000-L] Q: odbc, linux, mysql, replicate
>
>
> Jonny,
>
> > -----Original Message-----
> > From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> > Behalf Of Jonny Vatne
> > Sent: Saturday, February 09, 2002 12:03 PM
> > To: [log in to unmask]
> > Subject: [HP3000-L] Q: odbc, linux, mysql, replicate
> >
> >
> > Hi group, this is my first posting here.
> >
> > The company I work for have a hp3000 as the main computer, sales, orders
> > everything is stored in that box. We used the tool supplied with
'Formula
> > Industri 2001' to search the databases for information, but finally I
was
> > given the money to buy odbc-software from Minisoft. It works
> > fine, but slow,
> > we have BIG databases. :(
> > Using Minisoft-odbc software i made som stuff in Excel and they
> > seem to like
> > it, but now they want it all on out internal web-pages(sales, orders,
> > invoice......).
> >
> > The Hp3000 can give me all this information, but it is to slow, a
> > query can
> > take 2 mins and that is to long. I need to copy some tables from
> > the Hp3000
> > to mysql and make the webpages from mysql.
> > Has this been done by someone else, what kind of software do i need?
> >
> > TIA
> > Jonny Vatne
> > [log in to unmask]
> >
> > * To join/leave the list, search archives, change list settings, *
> > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> >
>
> <plug>
>
> For speedy access to your HP e3000, you need the ADBC
> Developer's Kit from Advanced Network System, Inc. ADBC is a
> Java API that allows complete native access to your HP e3000
> data eliminating the ODBC and SQL overhead. ADBC is platform
> and Operating System neutral; can be used from NT, Linux,
> Unix, HPe3000, Mac, etc. to dynamically integrate and
> present IMAGE data in Internet and Intranet web sites.
>
> Please contact me directly for web site links of companies
> who have mission-critical applications that had to replace
> ODBC with ADBC because of performance issues.
>
> ADBC is an integral component of our Open Commerce Services
> a framework aimed
> specifically at Companies who know they are reliant on
> limited life, high TCO, "Proprietary systems"; Companies who
> need to ensure that they achieve and maintain competitive
> edge through the new initiative of Internet and Intranet
> linked infrastructures.
>
> ANSI OCS are based on open standards that integrate with
> existing systems and can respond and evolve to rapid change.
> Our message is "Continue to develop with confidence on the
> HP e3000 knowing that the solutions are operating system,
> DBMS, and Hardware neutral". Regardless of choice of
> hardware, operating system, or DBMS, including MPE/iX or
> IMAGE , solutions written using the ANSI OCS frame-work
> will interoperate with other solutions that follow current
> industry open systems standards, with little if any
> reprogramming.
>
> OCS components include -
> ANSI Studio - extensible GUI IDE for evolving VPLUS clients
> ANSI Vplus+ Adaptors
> MPE/iX Enterprise Client and Enterprise Server - Oracle
> access from Your HPe3000.
> ADBC API for access to IMAGE, HP-Eloquence, and MPE FS and
> intrinsics (Existing business logic).
> J2EE Enterprise Resource Adapters for IMAGE, HP-Eloquence,SAP/R3 and
SAPDB.
> ANSI-Web - Fully compliant J2EE middle-tier application server
>
> http://www.advnetsys.com
>
> Please contact me directly for more information.
>
> Best Regards,
>
> </plug>
>
>
>
> --------------------------------------
>
> David A. Thatcher
> Advanced Network Systems Inc. ANSI
> http://www.advnetsys.com
> Voice: +1 908-638-3330
> Fax: +1 908-638-3331
> Email [log in to unmask]
>
> The Internet Agency, UK
> http://www.the-internet-agency.com
> European Distributors for Advanced Networks Systems Inc.
> Voice: +44 7836 364575
> Fax: +44 1202 418209
> Email [log in to unmask]
>
> -----------------------------------------
>
> ADBC is a registered trademark of Adager Corporation( www.adager.com ).
> Advanced Network System's ADBC Developer's Kit is a fully authorized
> implementation of the ADBC technology.
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
