Searching Multiple DBs

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11919
interpreted = N
texte = Blokes and Blokettes...I was trying to experiment with a fairly large database (160,000 records - 12 fields) that was a bit unmanageable as a single file (around 16 megs on disk), and so I thought I'd be clever and split it up into 12 different databases of roughly 15,000 records a piece.I was thinking I could perform a search treating all of these files as ONE, by doing something like:
Name: Company:
Which doesn't work, since it appears that it looks as the list of databases I gave it as one REALLY LONG filename.I've since re-joined the databases into ONE file and searching works fine (aside from needing TONS of RAM), but I could see searching multiple databases having the same form as being a rather useful function - so, is it possible or WILL it be possible in the future?Dan Keldsen - djk@delphigroup.com Director, I.S. - webmaster@delphigroup.com Delphi Consulting Group, Inc. - http://www.delphigroup.com/ 100 City Hall Plaza - ph: 617-247-1511 Boston, MA 02108-2106 - fax:617-247-4957 Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching multiple dbs (Kenneth Grome 1998)
  2. Searching multiple dbs (Robert Ruth 1998)
  3. Re: Searching Multiple DBs (Kenneth Grome 1997)
  4. Searching Multiple DBs (Dan Keldsen 1997)
Blokes and Blokettes...I was trying to experiment with a fairly large database (160,000 records - 12 fields) that was a bit unmanageable as a single file (around 16 megs on disk), and so I thought I'd be clever and split it up into 12 different databases of roughly 15,000 records a piece.I was thinking I could perform a search treating all of these files as ONE, by doing something like:
[cart]> Name: Company:
Which doesn't work, since it appears that it looks as the list of databases I gave it as one REALLY LONG filename.I've since re-joined the databases into ONE file and searching works fine (aside from needing TONS of RAM), but I could see searching multiple databases having the same form as being a rather useful function - so, is it possible or WILL it be possible in the future?Dan Keldsen - djk@delphigroup.com Director, I.S. - webmaster@delphigroup.com Delphi Consulting Group, Inc. - http://www.delphigroup.com/ 100 City Hall Plaza - ph: 617-247-1511 Boston, MA 02108-2106 - fax:617-247-4957 Dan Keldsen

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:

Orders to FMPro (2005) switching users (1998) Problem with updating to 2.1.1 (1998) Webcatalog Future?!? (2000) Almost a there but..bye bye NetCloak (1997) Displaying photo attached to first record (1997) ShowNext (1997) New Command prefs ... (1997) Need A Hired Gun :^) (1998) Shell and telnet (2002) WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) help with grep (2008) Virtual Postcard almost complete... (1998) WebStar Secure on other machine (1997) RE: New WebCatalog Version !!! (1997) form data submission gets truncated (1997) docs for WebCatalog2 (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) PCS Emailer's role ? (1997) Cart creation techniques (was Problems with Price field) (1997)