Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: running c++ program within database
A package is a collection of (hopefully related ) stored procedures and
functions.
Jim
<davidchantf_at_hotmail.com> wrote in message
news:BnzS6.5806$Zy.4340832_at_newsrump.sjc.telocity.net...
>
> Hi,
> I am already using Store Procedure for database query, Is package a
> collection of SP ?
> Is it package means more business logic in database ?
> Thanks.
> David
>
> Jim Kennedy <kennedy-family_at_home.com> wrote:
> > Are you using host variables? ODBC doesn't support host variables
natively.
> > (better to use OCI or OLE objects correctly) Not using host variables
would
> > possibly show up as high CPU utilization on the server machine.
> > Also you might try to do an explain plan on each type of query to see if
> > there are proper indexes etc.
> > Using pl/sql might be a good idea, it would mean that you are not
dragging
> > the information accross the network. It depends upon what you need to
do.
> > You would write a package and call the package from your c++ program.
> > Can you give us a flow of what you are doing?
> > Jim
> > <davidchantf_at_hotmail.com> wrote in message
> > news:2JOR6.1277$Zy.1232642_at_newsrump.sjc.telocity.net...
> >> Hi,
> >> I am using oracle ODBC 8.01.72, VC++ 6.0 on winnt 4.0. I have one
> >> operation that needs about 20*x database access, where x can be from 5
to
> >> 30.
> >> I can set up the program and database in one computer, but still
> >> slow. Right now I only have hundreds of records for testing, but in
> >> production mode, it can grow to millions of records.
> >> And the table design is complex and highly normailized.
> >> I never try to use PL/SQL, Is it a much better choice than ODBC ? Do I
> >> need to rewrite my program at all ?
> >> Thanks.
> >> David
> >>
> >> wayne <no_at_email.please.com> wrote:
> >> >> I have a C++ program that need to make a lot of database access
within
one
> >> >> operation, which is very slow. So I am wondering if I can run this
program
> >> >> inside database? so to reduce the number of database access, and
increase
> >> >> performance.
> >> > First of all, you would need to access the database anyway,
regardless
of
> >> > whether it's running on the database or outside.
> >> > Now, as far as performance optimization, there are lots of things you
could
> >> > do: Server-side tweaks as well as client-side... you can also
scrutinize
the
> >> > design of both the server and the overall process...
> >> > In answer to your question, I have never seen a C++ program be part
of
the
> >> > database itself. You can call out from the PL/SQL to the C++, but
the
C++
> >> > would have to be an external module (and may have to have a C
wrapper,
> >> > possibly), as in a DLL or SO file.
> >> > What would I do at this point if I were you (and I _have_ been in
your
> >> > situation before)? I would start with the overall design. Minor
tweaks
do
> >> > not help if the underlying design is bad. I would then move on to
> >> > optimizing the server and the client code (and what I would do
depends
> >> > heaviliy on what the exact tasks are and how long each takes to run).
> >> > If you describe your project more we can help more (ie. what
operations
are
> >> > being dome that take a long time, how many records are we talking
about,
> >> > what platform you run in, whether or not you are already running the
program
> >> > on the same machine as the server, etc...).
> >>
> >>
>
>
Received on Sun Jun 03 2001 - 19:18:32 CDT
![]() |
![]() |