Hi
I do not seem to be able to find the query analyser in manager studio 2008 is it installed as default or would it have been an optional install that I may have chosen not to include at the time of the install ?? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net <mailto:i...@trackingcentral.om.au> Website: www.SAMARIS.net <http://www.TrackingCentral.com.au> Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Andrew Scott Sent: Sunday, 26 September 2010 10:33 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Yeah, one has to remember though that the SQL Manager Studio will have events on each row read. For example if you have to window open to view records it will also take time to populate this as well. I know that the MS SQL MS is not the best designed or even optimised tool, and I would certainly not be using it as a benchmark to how fast the query should run, the Query Analyser in the Studio is designed to do this. Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Sunday, 26 September 2010 10:22 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Hi Andrew The table has 5965 records when I use this query in the sql analyser tool select club_id from members_table the sql analyser tool displays all 5965 records in under 2 seconds using the same query using the script screen in sql Manager Studio the results query took over 35 seconds ???? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net <mailto:i...@trackingcentral.om.au> Website: www.SAMARIS.net <http://www.TrackingCentral.com.au> Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Andrew Scott Sent: Sunday, 26 September 2010 9:58 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches I wasn't sure it would as you didn't have the % wrapping it anyway, so it might be the same as doing an equals. But the select * is known performance issue, and so is indexing the right columns as well to help speed things up. But I was surprised to see that the MS SQL Studio was slower in the tests you did, I know it converts select * to all columns but I doubt that would have brought on that much of a difference in running the queries. Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Sunday, 26 September 2010 9:59 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Optimising SQL Tables Searches Yes that was an oversight I made those changes to use = instead of like however doing so made no improvement in the speed, whilst not disputing your comments re using = rather than like Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net <mailto:i...@trackingcentral.om.au> Website: www.SAMARIS.net <http://www.TrackingCentral.com.au> Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
