Re: [WebDNA] listfiles weirdness?

This WebDNA talk-list message is from

2018


It keeps the original formatting.
numero = 113969
interpreted = N
texte = 1569 --001a11442e4434239e05650d8687 Content-Type: text/plain; charset="UTF-8" Gotcha, thanks again! I was close, but you helped me get it right! On Mon, Feb 12, 2018 at 6:52 PM, Kenneth Grome wrote: > > Question, that table is held in memory? > > Yes. > > > > On my local desktop it takes a moment or so to scan all those > > files, make the table etc. I'd like to avoid doing that each > > time another letter needs to be accessed. > > Write/rewrite a database via a separate script that's called by a > trigger at night when no one's browsing the website. Then search > the database instead of the table. > > :) > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us > archives: http://www.webdna.us/page.dna?numero=55 > Bug Reporting: support@webdna.us > --001a11442e4434239e05650d8687 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Gotcha, thanks=C2=A0again!

I was close,= but you helped me get it right!




On = Mon, Feb 12, 2018 at 6:52 PM, Kenneth Grome <ken@webdnasolutions.c= om> wrote:
> Question, that table is held in memory?

Yes.


> On my local desktop it takes a moment or so to scan all those
> files, make the table etc.=C2=A0 I'd like to avoid doing that each=
> time another letter needs to be accessed.

Write/rewrite a database via a separate script that's called by = a
trigger at night when no one's browsing the website.=C2=A0 Then search<= br> the database instead of the table.

:)

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration
----------------------------= -----------------------------
This message is sent to you because you are subscribed to
the mailing list talk@webdna.us
To unsubscribe, E-mail to: talk-lea= ve@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting:
support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --001a11442e4434239e05650d8687-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] listfiles weirdness? (Richard Kwasniewski 2018)
  2. Re: [WebDNA] listfiles weirdness? (Kenneth Grome 2018)
  3. Re: [WebDNA] listfiles weirdness? (Richard Kwasniewski 2018)
  4. Re: [WebDNA] listfiles weirdness? (Richard Kwasniewski 2018)
  5. Re: [WebDNA] listfiles weirdness? (Kenneth Grome 2018)
  6. Re: [WebDNA] listfiles weirdness? (Richard Kwasniewski 2018)
  7. Re: [WebDNA] listfiles weirdness? (Kenneth Grome 2018)
  8. [WebDNA] listfiles weirdness? (Richard Kwasniewski 2018)
1569 --001a11442e4434239e05650d8687 Content-Type: text/plain; charset="UTF-8" Gotcha, thanks again! I was close, but you helped me get it right! On Mon, Feb 12, 2018 at 6:52 PM, Kenneth Grome wrote: > > Question, that table is held in memory? > > Yes. > > > > On my local desktop it takes a moment or so to scan all those > > files, make the table etc. I'd like to avoid doing that each > > time another letter needs to be accessed. > > Write/rewrite a database via a separate script that's called by a > trigger at night when no one's browsing the website. Then search > the database instead of the table. > > :) > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us > archives: http://www.webdna.us/page.dna?numero=55 > Bug Reporting: support@webdna.us > --001a11442e4434239e05650d8687 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Gotcha, thanks=C2=A0again!

I was close,= but you helped me get it right!




On = Mon, Feb 12, 2018 at 6:52 PM, Kenneth Grome <ken@webdnasolutions.c= om> wrote:
> Question, that table is held in memory?

Yes.


> On my local desktop it takes a moment or so to scan all those
> files, make the table etc.=C2=A0 I'd like to avoid doing that each=
> time another letter needs to be accessed.

Write/rewrite a database via a separate script that's called by = a
trigger at night when no one's browsing the website.=C2=A0 Then search<= br> the database instead of the table.

:)

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration
----------------------------= -----------------------------
This message is sent to you because you are subscribed to
the mailing list talk@webdna.us
To unsubscribe, E-mail to: talk-lea= ve@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting:
support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --001a11442e4434239e05650d8687-- . Richard Kwasniewski

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebDNA-Talk Digest mode broken (1997) $append (1998) WebCat2b12 forgets serial # (1997) URL'ed value not written to DB URL'ed (2003) Problem searching bw & ne of a word (1999) access denied problem (1997) Practice runs ? (1997) [WebDNA] Conversion of 500.000 records; advise needed (2008) For those of you not on the WebCatalog Beta... (1997) Not really WebCat (1997) ReturnRaw and redirect one last question (1997) problem: search crashes webstar (1997) Mail Server Needed. (1998) Help with Shipping Costs (1997) Shipcost lookup? (1997) Page Counters? (1997) Cookie problems using Mozilla and Camino browsers (2004) Couple of questions (1999) [BULK] [WebDNA] Version 7 Config problem (2011) More on the email templates (1997)