Helen Borrie wrote:

> At 08:46 PM 28-08-01 -0300, C R Zamana wrote:
>
>
>> (...)
>
> There was a problem with the "loopback" for local access to
> SS on Linux, i.e. the connect time was (is?) horribly long
> (several minutes). Ann may recall more about this...
>
> Is it possible that your app is going through the connect
> process for *every* row? Since the performance you describe
> is absolutely absurd, it has to be something like this.

No. I connect just one time ( via /path/to/file.gdb )
and submit the statements ( open cursor/fetch/close, insert,
update etc ).

>
> And if something like this is forced by your application,
> then the client is being asked to get a fresh transaction
> handle for every insert.

This is interesting. When I'm doing the inserts I
can see the .gdb file increasing, but I cannot see the rows
inserted via isql in another session. To be able to do this
I need to "disconnect" and then "connect" again inside from
my application.

In this case I'm not doing this, of course.

>
> Have tried connecting to LOCALHOST instead of the local connect?

Sorry. What you mean?


Best regards.

--
------------------------------------------------------------------------
zamana@... | "Emacs is a nice OS - but it lacks a good text
zamana@... | editor. That's why I'm using Vim. Anonymous
http://www.inso.com.br | http://www.vim.org/quotes.html
------------------------------------------------------------------------