Re: querying on square-brackets, []

Article View: bionet.software.acedb

Article #160

Back to bionet.software.acedb Previous Next

#160

From: Dave Matthews
Date: Wed, 14 Aug 2002 15:04

26 lines
2580 bytes

Hi jean,

> 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

Yes, less than 1 second.


> 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

This one takes 6-7 seconds.  
I also tried it on a class with only 2000 objects and then it was < 1 sec.

- Dave
---

Technical Details

Message-ID: <200208141314.g7EDEtJ14340@greengenes.cit.cornell.edu>

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:52 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: matthews@greengenes.cit.cornell.edu (Dave Matthews)
Newsgroups: bionet.software.acedb
Subject: Re: querying on square-brackets, []
Date: 14 Aug 2002 16:04:50 +0100
Organization: BIOSCI/MRC Human Genome Mapping Project Resource Centre
Lines: 27
Sender: mod-ace@hgmp.mrc.ac.uk
Approved: BIOSCI Approval Key <biosci-approval-key@net.bio.net>
Message-ID: <200208141314.g7EDEtJ14340@greengenes.cit.cornell.edu>
NNTP-Posting-Host: mercury.hgmp.mrc.ac.uk
X-Trace: niobium.hgmp.mrc.ac.uk 1029337491 22746 193.62.192.80 (14 Aug 2002 15:04:51 GMT)
X-Complaints-To: news@net.bio.net
NNTP-Posting-Date: Wed, 14 Aug 2002 15:04:51 +0000 (UTC)
X-Received: from localhost (localhost [127.0.0.1])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 470BE17B9B
 for <acedb@hgmp.mrc.ac.uk>; Wed, 14 Aug 2002 14:15:02 +0100 (BST)
X-Received: from greengenes.cit.cornell.edu (greengenes.cit.cornell.edu [128.253.246.43])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id A763817C6D
 for <acedb@net.bio.net>; Wed, 14 Aug 2002 14:14:57 +0100 (BST)
X-Received: (from matthews@localhost)
 by greengenes.cit.cornell.edu (8.11.6+Sun/8.11.6) id g7EDEtJ14340;
 Wed, 14 Aug 2002 09:14:55 -0400 (EDT)
X-To: Jean Thierry-Mieg <mieg@ncbi.nlm.nih.gov>
X-Cc: ACEDB newsgroup <acedb@net.bio.net>,
 matthews@greengenes.cit.cornell.edu
X-Razor-id: aa138d3d42ed00b061070bef37edf7768a2ca637
X-Auth: PGPMoose V1.1 PGP bionet.software.acedb
 iQCVAwUAPVpxjqCIqsWvyF5FAQEnrAP/YoZHFpOCJBRyjVcKODQwXCeJGc161liC
 HwEyZ9shSTITVbiM/cwB2L1ON41HZWtYrpjwqYKCyuk30SR6jon9Nwm/tO9ZOrAY
 HrFY+SVPX/CrC5woAdG0h5JiBUCXUe9kgBzbUMPkEXb5tSnNd4nh0uJD28ODOyTQ
 e2D5h9CIfI4=
 =xWhI