15,000 insert /second ?
what about is this project ? stauroscope data? realtime image capturing ?
you can't find any standart database system to do this.
if your inserts need db for a few seconds immediatly, you can write them
quickly to an external table file and transfer them in idle time. or use a
special RAMDISK drive.
i think using API will not improve the performance, insert components are
allready lowest level.

----- Original Message -----
From: simpor81@...
To: ib-support@yahoogroups.com
Sent: Monday, January 29, 2001 8:07 PM
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


Yahoo! Groups Sponsor

www. .com




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