Is there a way to speed up a query?

AaronNash — Tue, 04 Jan 2011 19:10:21 GMT

I have an application that runs a query on an ArcServer 9.3.1 webservice and returns the values into a datagrid. When I did not specify query.where parameters and only queried the display field the query would return values in about 3 seconds. I needed to specify a second search parameter so I used radio buttons and created 2 different query.where expressions. This slowed down the results to 17-25 seconds. I changed the service to a webservice running on an ArcServer 10 machine with same results. Is there a way to speed up the query?

  private function doQuery():void
  {
   if (streetName.text == "")
   {
    Alert.show("Please Enter Text", "User Error");
   }
   else 
   {
   progressBar.visible = true;
   var query:Query = new Query();
   var pExpr:String = streetName.text.toUpperCase();
   pExpr = pExpr.replace(",","");
   pExpr = pExpr.replace("-","");
   pExpr = pExpr.replace(".","");
   var expr:String = queryExpr.replace("[value]", pExpr)
   query.where = expr;
   query.outFields = ["*"]
   query.returnGeometry = false;
   queryTask.execute(query, new AsyncResponder(onResult, onFault));
   function onResult(featureSet:FeatureSet, token:Object = null):void
   {
    progressBar.visible = false;
   }
   function onFault(info:Object, token:Object = null):void
   {
    progressBar.visible = false;
    Alert.show("No parcels were found", "Try something else");
   }
   }
  }

  //enable radion buttons to switch
  private function changesearch(event:ItemClickEvent):void
  {
   switch(event.label.toLowerCase())
   {
    case "street": 
    {
     txtLabelText.text = "Search Parcels by Street Name ex. Park Pl"
     queryExpr = "LocAddr LIKE '%[value]%'";
     autoCompleteMgr.enabled = true;
     break;
    }
    case "owner":
    {
     txtLabelText.text = "Search Parcels by Owner Name (Last Name First) ex. Smith John"
     queryExpr = "Owner1 LIKE '%[value]%'";
     autoCompleteMgr.enabled = false;
     break;
    }
   }
  }

thanks

Re: Is there a way to speed up a query?

EokNgo — Wed, 05 Jan 2011 00:01:18 GMT

You could try adding an index on those columns/fields you'll be querying such as LocAddr and Owner1.

topic Is there a way to speed up a query? in ArcGIS API for Flex Questions

Is there a way to speed up a query?

Re: Is there a way to speed up a query?