Re: querying on square-brackets, []

Article View: bionet.software.acedb

Article #163

Back to bionet.software.acedb Previous Next

#163

From: Jean Thierry-Mieg
Date: Wed, 14 Aug 2002 15:04

52 lines
2709 bytes

I guess that what is happening is the following

query:: enters full query syntax
[] initiate arithmetic mode and force the opening of the objects

please try the following 2 tests, i expect both of them to
complete immediatly

test 1:
find sequence [AL505438.1]

this should be fast because find not preceded by query
does the same as the acedb graphic main window top yellow box
that is a strict name search without interpretation

test 2:
query find sequence IS "[AL505438.1]"

this is the fully pedantic form of the query
the presence of IS forces evaluation of name matching

if you are running some kind of web service with a midleware cgi
you should always form the query like in test 2, and inside the string
protect the eventual " \ or // with a \


====

please let me know ASAP of the test  result
jean



>this query takes 10 minutes to execute in GrainGenes,
>
>  query find sequence [AL505438.1]
>
>Whereas the following queries all complete in less than a second except
>as noted.
>
>  query find sequence (AL505438.1)
>  query find sequence {AL505438.1}
>  query find sequence "[AL505438.1]"
>  query find probe [AL505438.1]      7 seconds
>  find sequence [AL505438.1]
>

>- Dave
>
>---
>

Technical Details

Message-ID: <200208141230.g7ECU1227340@mx.nlm.nih.gov>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6d40,3f8543bfeb0403ea
X-Google-Attributes: gidf6d40,public
X-Google-ArrivalTime: 2002-08-14 08:04:55 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net
From: Jean Thierry-Mieg <mieg@ncbi.nlm.nih.gov>
Newsgroups: bionet.software.acedb
Subject: Re: querying on square-brackets, []
Date: 14 Aug 2002 16:04:54 +0100
Organization: BIOSCI/MRC Human Genome Mapping Project Resource Centre
Lines: 53
Sender: mod-ace@hgmp.mrc.ac.uk
Approved: BIOSCI Approval Key <biosci-approval-key@net.bio.net>
Message-ID: <200208141230.g7ECU1227340@mx.nlm.nih.gov>
Reply-To: Jean Thierry-Mieg <mieg@ncbi.nlm.nih.gov>
NNTP-Posting-Host: mercury.hgmp.mrc.ac.uk
Mime-Version: 1.0
Content-Type: TEXT/plain; charset=us-ascii
X-Trace: niobium.hgmp.mrc.ac.uk 1029337494 22748 193.62.192.80 (14 Aug 2002 15:04:54 GMT)
X-Complaints-To: news@net.bio.net
NNTP-Posting-Date: Wed, 14 Aug 2002 15:04:54 +0000 (UTC)
Content-MD5: N/YQTbhhRSjcXkSETq720A==
X-Virus-Scanned: by amavisd-milter ( http://amavis.org/ )
X-Razor-id: 1f2fcb547464ed8ed2ee65bdc335e316313ff231
X-Auth: PGPMoose V1.1 PGP bionet.software.acedb
 iQCVAwUAPVpxkqCIqsWvyF5FAQEjDAP+IDA609dvGjK8mM9LeCH4ScFzrAC7FAPC
 IU8cZxWr4hC/ohvUd903Wu7kFLHb+X54LIlh8MtxYJM9IMYkRJJWGNIaJItIdYUb
 qD3k69caKOx+o1Rj2nS0ptuMjKiDgfSIDJTIMmQbBy9SNl4YPeolFn89H3ZvBNAC
 y7HVB7zK7G4=
 =FveW