08-23-2002
Being that I've worked with Seagate Info (the automation of reporting for Crystal Reports), I can say that it should not crush the "entire" server.
You may want to rework the query - it's taking too long not because the server can't handle it, but because the SQL query is slow or not using the proper indexes.
Also, if you have 100 distributions of each report, rather than running the same query for each report, you can run a query out to disk, then run the report against the disk file... Works much better.
I'm not familiar with the exact product that you're using, but there could be many generic reasons, such as the above, that could cause this.
Also, are the reports being run on the Unix box, or does that just house the database?
10 More Discussions You Might Find Interesting
1. BSD
HEllo,
I try to Launch OOO, but I have X configuration problem.
I 'm searching in man pages but if someone can help me...
Of course I set the DISPLAY as explain in the man page but with no more result: setenv DISPLAY myws:0
Thanks in advance (1 Reply)
Discussion started by: SoulCoder
1 Replies
2. Red Hat
Hi, I'm just wanna configure dhcp server using redhat enterprise 4.0 as. can anyone help me on this, on setting using two NICs.
Thankx. (1 Reply)
Discussion started by: johan_sysv
1 Replies
3. Post Here to Contact Site Administrators and Moderators
how to configure servor dns on windows servor 2003 (0 Replies)
Discussion started by: djest
0 Replies
4. Linux
hello,
I don't know how to configure servor dns on linux,please help I thanck YOU (1 Reply)
Discussion started by: djest
1 Replies
5. AIX
I have an RS/6000 running AIX 5.3. I would like to get either dhcp client working or assigning it an ip would be fine as well. I have tried using smit to do it many times trying different things, and I can get an ip assigned but it doesn't communicate with the network or internet. I haven't been... (3 Replies)
Discussion started by: izzzy
3 Replies
6. Shell Programming and Scripting
Hi all
This is my /etc/alliases configuration...in that i configure whenever i send mail form root The receivers want to receive from the mail id 07anis@gmail.com but it not works...is there any mistake iam doing?? Please Guide me to resolve this issue..
With Regards
Anish Kumar.V (1 Reply)
Discussion started by: anishkumarv
1 Replies
7. Emergency UNIX and Linux Support
Hi,
We have a standalone Solaris 10 Server (no DNS is configured) from which we want email alerts to be triggered when there is any breaches in the disk utilization threshold levels. we would like to achieve this mailing through sendmail.
Can any one explain the procedure to do so..???
... (1 Reply)
Discussion started by: EmbedUX
1 Replies
8. Solaris
I m using Intel solaris 10 version . I m trying to install openldap and used several documents and package versions .
But every time I got CC PATH error and while I solved the CC issue , I got Barkley DB error . :wall:
Is there any perticular site from where I can install and configure... (1 Reply)
Discussion started by: sanjee
1 Replies
9. AIX
Can someone help setting up snmpv3? (1 Reply)
Discussion started by: dunman22
1 Replies
10. Shell Programming and Scripting
Hi All,
I need to configure mail functionality which enable us to send mail to outside company network. I just came to know that we have to configure outbound mail host/relaying mail in sendmail.cf file.
Can someone suggest me on what to change in sendmail.cf, what information is required... (0 Replies)
Discussion started by: ace_friends22
0 Replies
LEARN ABOUT SUNOS
wsreg_query_create