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] Where is Speed Test? (2009) Weird problems with [SHOWIF]s (1997) Setting up WebCatalog with Retail Pro data (1996) Spamming this list! (2000) absolute paths for databases? (1997) Sort of a Dilemma! (1998) Help! WebCat2 bug (1997) [random] only for 1-100??? (1997) Multiple catalog databases and showcart (1997) Summary search -- speed (1997) How many Databases can I open? (2003) WC Database Format (1997) [Sum] function? (1997) bug in [SendMail] (1997) remotely add + sign (1997) frames & carts (1997) Re:What file? (1997) Cart/Cookie question (2005) Sorting by date (1997) WebCat on 10.0.4 - iTools 6.0 (2001)