Simon,

15000 in 1 sec -- Not likely!!!

15000 in 5-10 sec - very likely!

I suspect that your problem is that your inserts/updates are being
auto-committed.


Sean

-----Original Message-----
From: simpor81@... [mailto:simpor81@...]
Sent: Monday, January 29, 2001 1:08 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Writing data in tables!

Well I have tried to use ibobjects and it's going to slow. And the
C++ code that you can get on www.ibpp.org doesn't seem to work for
me, so I tried to take a try for my self and it doesn't work at all.

In my program does I heva to write 15000 post to tables, the primary
goal is that this will take just a sec. Now it's taking (with
ibobjects) around 2 min. So I did think that using Interbase API
directly would make this a little bit faster.

In my database I have a table that looks pretty much like the
DEPARTMENT table in employee.gdb, it's in a table like that, that I
would like to write 15000 posts.

Is there any other way to read very fast to Interbase???

Simon

--- In ib-support@y..., Olivier Mascia <om@t...> wrote:
> Simon,
>
> Is this going to be a full application (with lots of GUI/Database
> interactions) or something more of a tool or legacy code in which
you need
> to add access to IB ?
>
> In the first case, I'd recommend IBO (www.ibobjects.com), though
written in
> Delphi, will work in your C++ Builder project.
>
> In the second case, I'd recommend a thin C++ wrapper around the IB
C-API,
> so the intricacies of the C-API do not obscure your own code
(www.ibpp.org).
>
> Olivier Mascia
>
> --On lundi 29 janvier 2001 17:09 +0000 simpor81@h... wrote:
>
> > I'm using Borland C++ Builder 5.0. And the programming language
C/C++.
> >
> >> --On lundi 29 janvier 2001 16:44 +0000 simpor81@h... wrote:
> >>
> >> > Hello!
> >> >
> >> > I have problems when I'm trying to write data to a table. How
are
> > you
> >> > supposed to do it???
> >> >
> >> > I have managed to connect to the database (at least I think
that I
> >> > have) but when I try to write to a table it craches the hole
time.
> >> >
> >> > I'm using the isc_dsql_execute_immediate. But I need to use a
SQL
> >> > with parameters. How does the code look like when you write to
a
> >> > table in employee.gdb "Any table will do". I will be able to
write
> >> > let us say 100 new post to it.
> >> >
> >> > Thanks for all the help!
> >> >
> >> > Simon



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com