Hi,

I have a  local DBISAM session embedded in an Intraweb application.  It uses
a mix of Table and Query components to perform fairly complex database
operations; particularly using FindNearest with Prior etc type operations.

I would now like to move to a remote database session to allow me to have
multiple Intraweb Application Servers connecting to a single ElevateDB
Database Server; of course, for performance reasons it isn't practical to
simply change the session type.  It will be difficult to achieve the same
degree of functionality through SQL, therefore I was very interested to read
that ElevateDB can execute DLLs.

Can anyone tell me if it is possible to use Delphi to create procedures that
uses ElevateDB table components in the normal way, but have them
encapsulated in a DLL to be invoked via SQL stored procedures?

Thanks,
Jack

Jack


If I'm understanding your needs correctly then it should be easily possible, as long as the Delphi code is self contained. You can pass parameters in but those would be limited to the datatypes handled by ElevateDB.

Its not overly difficult to do and is the sort of thing I do for preprocessing text for indexing, but I'm not opening any other tables.

I'd also suggest you have a look at ElevateDB's SQL/PSM language - you may find it can do what you want.

Roy Lambert [Team Elevate]

Thanks Roy.

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:337526B2-5C72-4264-862B-F154CD0816DD@news.elevatesoft.com...
> Jack
>
>
> If I'm understanding your needs correctly then it should be easily
> possible, as long as the Delphi code is self contained. You can pass
> parameters in but those would be limited to the datatypes handled by
> ElevateDB.
>
> Its not overly difficult to do and is the sort of thing I do for
> preprocessing text for indexing, but I'm not opening any other tables.
>
> I'd also suggest you have a look at ElevateDB's SQL/PSM language - you may
> find it can do what you want.
>
> Roy Lambert [Team Elevate]
>

Do PSM procedures get compiled or are they interpreted every time that they
are executed?

What I am trying to understand is whether or not there is a performance
benefit in using DLLs versus PSM (or vice-versa).

Thanks,
Jack

Jack

>Do PSM procedures get compiled or are they interpreted every time that they
>are executed?

That one I'm going to let Tim (when he's sobered up from the party) answer. I think they're compiled but not in the same way a Delphi app is. My understanding in this area is weak.

>What I am trying to understand is whether or not there is a performance
>benefit in using DLLs versus PSM (or vice-versa).

Regardless of the answer about compilation the answer to this is the good old "that depends". Can you post a couple of examples of what you're wanting to do? That way we might be able to give some better advice.

Roy Lambert [Team Elevate]

Jack

I've just looked at your web site. I thought the time sync was a bit to good - you must be my nearest fellow DBISM/ElevateDBer at only 250 miles south - I'm in Lybster, Caithness.

Roy Lambert

Roy Lambert wrote:

> Jack
>
> I've just looked at your web site. I thought the time sync was a bit to good - you must be my nearest fellow DBISM/ElevateDBer at only 250 miles south - I'm in Lybster, Caithness.
>
> Roy Lambert

Hmmm, there could be a contest here!
Google says I am only 242 miles away (EH4 2JL)!

Malcolm

--

Jack,

<< Do PSM procedures get compiled or are they interpreted every time that
they are executed? >>

They are compiled into binary tokens that are then executed.  Once a stored
procedure is compiled (prepared), it stays compiled until it is destroyed or
unprepared.

<< What I am trying to understand is whether or not there is a performance
benefit in using DLLs versus PSM (or vice-versa). >>

The PSM is pretty efficient, so the issue is really one of which coding
method you prefer.

--
Tim Young
Elevate Software
www.elevatesoft.com

Malcolm


That's three of us - we could start a user group

Roy Lambert

Tim


>They are compiled into binary tokens that are then executed. Once a stored
>procedure is compiled (prepared), it stays compiled until it is destroyed or
>unprepared.

Is that like the old BASIC tokenising?

and

SHOULDN'T YOU BE AT/GETTING READY FOR THE PARTY?????

Roy Lambert