IUBio

query optimisation

Danielle et jean Thierry-Mieg mieg at beta.crbm.cnrs-mop.fr
Sun Aug 15 13:32:21 EST 1999


somebody says:

 acedb> find probe
>                                        1 sec
> // Found 8169 objects in this class
> 
> acedb> follow sequence
>                                        7 sec
> // Found 1636 objects
> 
> acedb> query find sequence probe     [64570 Sequence objects]
>                                      150 sec
> // Found 1636 objects



actually is Probe was an indexed tag (declared in subclasses.wrm)
or simply a level 1 tag (from the first column) in which case it is
indexed by default in acedb 4_7
 acedb> query find sequence probe     [64570 Sequence objects]
 would probably take around 1 sec

---




More information about the Acedb mailing list

Send comments to us at biosci-help [At] net.bio.net