Let the Server do the Work 
Author Message
 Let the Server do the Work

I've developed a little program in VB 6.0 that
interrogates our Oracle Database and produces reports etc.
but runs very slow due to speed of the workstation.

I will have to install this program on other workstations
so I will have to install the Oracle Client on all the
PC's.

Is it at all possible to get our Windows 2000 Server to do
all the processing and use that as the Oracle Client or
will I have to redevelop the program in Interdev?

Thanks in advance.

Rob



Mon, 03 Jan 2005 23:14:02 GMT  
 Let the Server do the Work
Technically it can be done, I have done similar in the past but it is
impossible to say for certain without knowing more details about your
application, its input and its output. If you are using 3rd party reporting
components (say Crystal Reports) then you can build your own print servers
to handle requests and printouts for example.

--
Mike Collier BSc (Hons) - www.adoanywhere.com
ADO Object Browser and COM Server.
Consultancy and Design - ADO & Database Specialists.


Quote:
> I've developed a little program in VB 6.0 that
> interrogates our Oracle Database and produces reports etc.
> but runs very slow due to speed of the workstation.

> I will have to install this program on other workstations
> so I will have to install the Oracle Client on all the
> PC's.

> Is it at all possible to get our Windows 2000 Server to do
> all the processing and use that as the Oracle Client or
> will I have to redevelop the program in Interdev?

> Thanks in advance.

> Rob



Tue, 04 Jan 2005 01:28:16 GMT  
 Let the Server do the Work
Thanks for the reply Mike.
The application I've created is called Multi-Level Where
Used. It looks at an Oracle Table containing Bill of
Materials for a Product. A Product may have a maximum of 6
levels of components.

Product +
        |-Part1
        |-Part2+
        |      |-Part2a
        |-Part3
Due to the limitations of Crystal Reports regarding a sub-
report of a sub-report I've got to extract the component
details of level 1 then 2 etc. The extracted data is
appended to an Access Database on the Client PC which I
then use Crystal to report from.

I think the best plan would be to Append the various SQL
Queries to an Oracle Table on the Server then report off
that Table instead off pulling the data across the Lan.

What do you think?

Thanks
Rob

Quote:
>-----Original Message-----
>Technically it can be done, I have done similar in the
past but it is
>impossible to say for certain without knowing more
details about your
>application, its input and its output. If you are using
3rd party reporting
>components (say crystal reports) then you can build your
own print servers
>to handle requests and printouts for example.

>--
>Mike Collier BSc (Hons) - www.adoanywhere.com
>ADO Object Browser and COM Server.
>Consultancy and Design - ADO & Database Specialists.



>> I've developed a little program in VB 6.0 that
>> interrogates our Oracle Database and produces reports
etc.
>> but runs very slow due to speed of the workstation.

>> I will have to install this program on other
workstations
>> so I will have to install the Oracle Client on all the
>> PC's.

>> Is it at all possible to get our Windows 2000 Server to
do
>> all the processing and use that as the Oracle Client or
>> will I have to redevelop the program in Interdev?

>> Thanks in advance.

>> Rob

>.



Tue, 04 Jan 2005 05:47:08 GMT  
 Let the Server do the Work
Quote:
> I think the best plan would be to Append the various SQL
> Queries to an Oracle Table on the Server then report off
> that Table instead off pulling the data across the Lan.

That should work OK.

(By the way...There is a trick you can use for BOM tables if your database
can handle recursive stored procedures. It is possible to build a database
procedure that traverses the BOM tree to "infinite" levels and produce the
output in the form of a table. Unfortunately I have only implemented this in
Interbase).

--
Mike Collier BSc (Hons) - www.adoanywhere.com
ADO Object Browser and COM Server.
Consultancy and Design - ADO & Database Specialists.


Quote:
> Thanks for the reply Mike.
> The application I've created is called Multi-Level Where
> Used. It looks at an Oracle Table containing Bill of
> Materials for a Product. A Product may have a maximum of 6
> levels of components.

> Product +
>         |-Part1
>         |-Part2+
>         |      |-Part2a
>         |-Part3
> Due to the limitations of Crystal Reports regarding a sub-
> report of a sub-report I've got to extract the component
> details of level 1 then 2 etc. The extracted data is
> appended to an Access Database on the Client PC which I
> then use Crystal to report from.

> I think the best plan would be to Append the various SQL
> Queries to an Oracle Table on the Server then report off
> that Table instead off pulling the data across the Lan.

> What do you think?

> Thanks
> Rob

> >-----Original Message-----
> >Technically it can be done, I have done similar in the
> past but it is
> >impossible to say for certain without knowing more
> details about your
> >application, its input and its output. If you are using
> 3rd party reporting
> >components (say crystal reports) then you can build your
> own print servers
> >to handle requests and printouts for example.

> >--
> >Mike Collier BSc (Hons) - www.adoanywhere.com
> >ADO Object Browser and COM Server.
> >Consultancy and Design - ADO & Database Specialists.



> >> I've developed a little program in VB 6.0 that
> >> interrogates our Oracle Database and produces reports
> etc.
> >> but runs very slow due to speed of the workstation.

> >> I will have to install this program on other
> workstations
> >> so I will have to install the Oracle Client on all the
> >> PC's.

> >> Is it at all possible to get our Windows 2000 Server to
> do
> >> all the processing and use that as the Oracle Client or
> >> will I have to redevelop the program in Interdev?

> >> Thanks in advance.

> >> Rob

> >.



Tue, 04 Jan 2005 08:59:40 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Where is work done on client or server?

2. How can I let work my PopUpMenu?

3. HELP - Graphics Server Not Letting Go!!

4. letting ActiveX ocx access data on the server.

5. Using ASP to let a webuser write text file on the server

6. ADSI Object (Lets you enumerate users, servers, groups, shares, It's the business)

7. Refresh/Requery don't seem to work while doing file I/O

8. Doing a SaveAs without renaming the working document

9. What am I doing wrong?? (working with Inet)

10. Limits to work done between commits

11. ASP works on Personal Web Server, but not on remote server

12. DHTML/SQL Server app works fine internally, not on web server

 

 
Powered by phpBB® Forum Software