Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Re: How to achi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 22 of 23 Topic 30626 of 31573
Post > Topic >>

Re: How to achieve scalability

by lyle fairfield <lylefa1r@[EMAIL PROTECTED] > Jul 4, 2008 at 02:42 PM

The Frog <Mr.Frog.to.you@[EMAIL PROTECTED]
> wrote in news:74a5e2d0-406b-
4292-8732-b1b714e0a244@[EMAIL PROTECTED]
> OK, here is a quick test on the simil() function done in vba as
> follows:
> 
> Debug.Print "Start time: " & Now()
> For i = 1 To 700000
>     score = Simil("The Yummy and Tasty Waffle Cor****ation",
> "TASTYWAFFLE")
> Next
> Debug.Print "Finish time: " & Now()
> Debug.Print score
> 
> and the results are:
> Start time: 4/07/2008 9:19:55 AM
> Finish time: 4/07/2008 9:21:13 AM
>  0.448979591836735

No need for Viagra here; the process is already incredibly long.
> 
> I would love to run a test with this using SALAD's ShortName function
> and see if the score is higher.

I called ShortName with your parameters for a million iterations. Took 
six seconds.

I ran the a RegExp with the same functionanlity. Took one second.

> To answer Lyle's "Why Not?" : The difference between probability and
> certainty. While ambiguity exists you can only ever assign a
> probability that one one thing is another (or equal to another), and
> as such there is always a margin of error (a chance they are not the
> same). As a result you cannot guarantee 100% effectiveness for any
> query of this type where a probabilistic determination is involved.
> The best you can do manage / minimise the risks by setting your P
> cutoff threshold high enough for the result of the query to be
> considered significant enough to be trusted.

There is no certainty, except that CDMA will have a whole bunch of stupid 
posts. But I am SURE I could run a regexp 10^n (where n is a very large 
number) times without any error .
 




 23 Posts in Topic:
How to achieve scalability
"Carlos Nunes-Ueno&q  2008-07-02 00:45:11 
Re: How to achieve scalability
lyle fairfield <lyle.f  2008-07-01 18:28:36 
Re: How to achieve scalability
"Carlos Nunes-Ueno&q  2008-07-02 02:05:28 
Re: How to achieve scalability
Tom van Stiphout <no.s  2008-07-01 22:02:27 
Re: How to achieve scalability
"Carlos Nunes-Ueno&q  2008-07-02 15:59:43 
Re: How to achieve scalability
"Tony Toews [MVP]&qu  2008-07-03 02:34:49 
Re: How to achieve scalability
The Frog <Mr.Frog.to.y  2008-07-02 00:40:42 
Re: How to achieve scalability
Tom van Stiphout <no.s  2008-07-02 20:49:02 
Re: How to achieve scalability
"David W. Fenton&quo  2008-07-03 22:35:23 
Re: How to achieve scalability
The Frog <Mr.Frog.to.y  2008-07-02 01:35:21 
Re: How to achieve scalability
lyle fairfield <lyle.f  2008-07-02 03:06:22 
Re: How to achieve scalability
"Carlos Nunes-Ueno&q  2008-07-02 17:07:18 
Re: How to achieve scalability
Tom van Stiphout <no.s  2008-07-02 21:07:42 
Re: How to achieve scalability
lyle fairfield <lylefa  2008-07-03 16:25:34 
Re: How to achieve scalability
lyle fairfield <lylefa  2008-07-03 23:00:50 
Re: How to achieve scalability
Salad <oil@[EMAIL PROT  2008-07-02 10:36:14 
Re: How to achieve scalability
lyle fairfield <lylefa  2008-07-03 16:26:56 
Re: How to achieve scalability
The Frog <Mr.Frog.to.y  2008-07-03 00:11:22 
Re: How to achieve scalability
Salad <oil@[EMAIL PROT  2008-07-03 07:15:10 
Re: How to achieve scalability
lyle fairfield <lyle.f  2008-07-03 07:43:01 
Re: How to achieve scalability
The Frog <Mr.Frog.to.y  2008-07-04 00:32:24 
Re: How to achieve scalability
lyle fairfield <lylefa  2008-07-04 14:42:46 
Re: How to achieve scalability
The Frog <Mr.Frog.to.y  2008-07-07 03:19:39 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 23:19:35 CST 2008.