x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 239 subscribers
  • Views 2757 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
runlevel6

Slow ODBC Queries

Posted By

Hello All,

I have a problem I have been researching lately regarding slow queries over ODBC to our sage server. I have seen people with similar issues on other sites, but no real solutions....

We have a web server that uses PHP to query several database servers including a Microsoft SQL server, a Linux MySQL server, and our Sage accounting server. Connections to MSQL and MySQL servers are responsive, but when it comes time to query the Sage server (which uses ODBC, and I am told by Sage support this is the only way you can), you go get a cup of coffee...

Our other servers have as much, if not more, data as the Sage server, and the queries being written are not complex...usually simple select statements. I know the problem is not networking or hardware etc, given that connections to other, more taxed servers with more complex queries respond well. The problem seems to be with ODBC

Does anyone have experience with this? Can you point me in the direction of possible solutions?

Parents
  • 0

    Hi runlevel6,

    One thing you may check is the security in Sage 300 Construction, specifically Record Level Security. If you have it enabled, you may try turning it off temporarily by launching Sage Desktop, Tools, Security Administration, Records and clearing the check box labeled Activate Record Security.

Reply
  • 0

    Hi runlevel6,

    One thing you may check is the security in Sage 300 Construction, specifically Record Level Security. If you have it enabled, you may try turning it off temporarily by launching Sage Desktop, Tools, Security Administration, Records and clearing the check box labeled Activate Record Security.

Children
  • 0 in reply to Jesse Gordon

    We bought Anterra and dump our STO data out to a SQL Server three times a day. It depends how big a shop you have and what you're using it for, but essentially the same Crystal Reports that run against Anterra's copy are 10x or more faster, and you can use the query analyzer to optimize indexes on the tables to make the reports run even faster. The Anterra people have been good with prescriptive suggestions, it's a pretty straightforward product. The Contract Assistants can run their JC reports whenever they want now, instead of having to plan it around break time. The hitch has been getting My Assistant to use those reports, so we're working on it in Visual CUT.

*Community Hub is the new name for Sage City