Groups > microsoft.public.scripting.vbscript > #12332

Re: Why does a loop using instr() and mid() get slower on larger data ? - found it (I think)

From	"R.Wieser" <address@not.available>
Newsgroups	microsoft.public.scripting.vbscript
Subject	Re: Why does a loop using instr() and mid() get slower on larger data ? - found it (I think)
Date	2021-01-03 16:01 +0100
Organization	Aioe.org NNTP Server
Message-ID	<rssm7m$5ai$1@gioia.aioe.org> (permalink)
References	(3 earlier) <rsqku7$ksc$1@dont-email.me> <rsqnho$157m$2@gioia.aioe.org> <rsqs1f$5le$1@dont-email.me> <rsrtfa$1v8c$1@gioia.aioe.org> <rssian$hjo$1@dont-email.me>

Show all headers | View raw

Mayayana,

> | The whole process using the 25 MB string still takes several
> | seconds to complete though.  Oh well.

>  Did you try a UCase or LCase first and then ReadAll?

Whut ?   How do you suppose I would be able to do that ?    I would think I 
would need to read the data before being able to act upon it ....

> I don't see the point of reading by line

The drawback of reading everything into memory and doing an initial lcase or 
ucase is that you have to assume that none of the files data is in a 
mixed-case form thats important to the user.   In my case the OSM file 
contains name of streets, etc.   Those I would like to keep the casing.

> I imagine it might also depend on the length
> of the search string and how many similarities
> there are.

Ofcourse!  And as such not something I would think twice about.

Regards,
Rudy Wieser

Back to microsoft.public.scripting.vbscript | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Why does a loop using instr() and mid() get slower on larger data ? "R.Wieser" <address@not.available> - 2021-01-02 12:41 +0100
  Re: Why does a loop using instr() and mid() get slower on larger data ? "Mayayana" <mayayana@invalid.nospam> - 2021-01-02 08:39 -0500
    Re: Why does a loop using instr() and mid() get slower on larger data ? "R.Wieser" <address@not.available> - 2021-01-02 16:46 +0100
      Re: Why does a loop using instr() and mid() get slower on larger data ? "Mayayana" <mayayana@invalid.nospam> - 2021-01-02 15:26 -0500
        Re: Why does a loop using instr() and mid() get slower on larger data ? "R.Wieser" <address@not.available> - 2021-01-02 22:11 +0100
          Re: Why does a loop using instr() and mid() get slower on larger data ? "Mayayana" <mayayana@invalid.nospam> - 2021-01-02 17:27 -0500
            Re: Why does a loop using instr() and mid() get slower on larger data ? - found it (I think) "R.Wieser" <address@not.available> - 2021-01-03 08:58 +0100
              Re: Why does a loop using instr() and mid() get slower on larger data ? - found it (I think) "Mayayana" <mayayana@invalid.nospam> - 2021-01-03 08:54 -0500
                Re: Why does a loop using instr() and mid() get slower on larger data ? - found it (I think) "R.Wieser" <address@not.available> - 2021-01-03 16:01 +0100
                Re: Why does a loop using instr() and mid() get slower on larger data ? - found it (I think) "Mayayana" <mayayana@invalid.nospam> - 2021-01-03 12:51 -0500
                Re: Why does a loop using instr() and mid() get slower on larger data ? - found it (I think) "R.Wieser" <address@not.available> - 2021-01-03 19:26 +0100
          Re: Why does a loop using instr() and mid() get slower on larger data ? "Mayayana" <mayayana@invalid.nospam> - 2021-01-02 17:43 -0500
  Re: Why does a loop using instr() and mid() get slower on larger data ? JJ <jj4public@gmail.com> - 2021-01-03 02:47 +0700
    Re: Why does a loop using instr() and mid() get slower on larger data ? "R.Wieser" <address@not.available> - 2021-01-02 21:47 +0100

csiph-web