Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Turbo Performance Expand / Collapse
Author
Message
Posted Tuesday, October 11, 2005 2:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 23, 2007 6:35 AM
Points: 5, Visits: 1

Has anyone had issues with the SQL Turbo built in stored procedures having slow performance?

We are trying to page the top 2000 results. Here is the general query I am passing into the server:

declare @sql varchar(5000)
 
 select @sql = '
 SELECT top 2000 pl.id
 FROM dbo.business (nolock)
 JOIN dbo.listings l (nolock) on l.businessid = business.businessid
 JOIN dbo.nearby n WITH (Nolock) on l.ZIPID = n.NearbyZIPID
WHERE {business_idx=$''STERILIZES''}
 AND (n.zipid = 16814)  '

 exec tdbExecuteReturnPageL @sql, 3, 20
GO

The tables are business, listing (locations of a a business), and nearby (a list of local zipcodes). We have horrible response times when the number of users increases.  Also, the results per page vary - sometimes we get all 20 for the page, other times, only 5 records are returned!

Is there any issue with the statement or how we are going about this?

Thanks,
Nick

Post #228105
Posted Wednesday, October 12, 2005 9:53 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:50 AM
Points: 1,356, Visits: 5,674

I'm not sure what {business_idx=$''STERILIZES''} does.

The query looks fine if there are indexes on businessid, ZIPID.

What does exec tdbExecuteReturnPageL @sql, 3, 20 ?

 

Post #228364
Posted Wednesday, October 12, 2005 2:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 23, 2007 6:35 AM
Points: 5, Visits: 1

Yes, there are indexes on both.

The strange text is SQL Turbo related code - what they say to use - to find anything in the index that is like "sterilizes". I could have anything in the search word - right now I've hardcoded it.

tdbExecuteReturnPageL is the SQL Turbo provided stored procedure for returning paged results.

Post #228451
Posted Wednesday, October 12, 2005 5:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 17, 2007 4:24 PM
Points: 8, Visits: 3

Quest Software SQL Turbo is for full text searches. From Quest's website "SQL Turbo is a revolutionary new software tool which dramatically increases the speed of SQL Server's free text retrieval."

I would be nearly impossible for us to determine what is going on inside their stored procedures. You should contact the vendor for help.

Post #228508
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse