From jan@swi.psy.uva.nl  Thu Mar 30 11:53:53 2000
Received: from gollem.swi.psy.uva.nl (root@gollem [145.18.152.30])
	by swi.psy.uva.nl (8.9.3/8.9.3) with ESMTP id LAA04467
	for <prolog@swi.psy.uva.nl>; Thu, 30 Mar 2000 11:53:53 +0200 (MET DST)
Received: from localhost (localhost [[UNIX: localhost]])
	by gollem.swi.psy.uva.nl (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) id LAA03618
	for prolog; Thu, 30 Mar 2000 11:54:07 +0200
From: Jan Wielemaker <jan@swi.psy.uva.nl>
Organization: SWI, University of Amsterdam
To: prolog@gollem.swi.psy.uva.nl
Subject: PrologSQL on Unix, Anyone?
Date: Thu, 30 Mar 2000 10:56:31 +0200
X-Mailer: KMail [version 1.0.28]
Content-Type: text/plain
MIME-Version: 1.0
Message-Id: <00033011540701.02859@gollem>
Content-Transfer-Encoding: 8bit

Hi,

I am scanning through Sergey Sikorsky's PrologSQL, hoping I could use
it on Unix with mySQL or similar database.  I'm not much of a database
guy, but I understand it is not entirely trivial.

PrologSQL builds on OTL, a C++ for OCI (Oracle Call Interface)
and ODBC.  So the fundamental question is, can I get OTL to talk to
mySQL?  Anyone with experience?

Second question is on performance.  I needs this database to store
about 2,500,000 (short-)string-tripples, indexed on one of the
arguments. What kind of performance can I expect to retrieve an indexed
tripple?  Modifying does not need to be fast.

	Thanks --- Jan

