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:
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:
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:
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:
[BULK] [WebDNA] [BULK] WebDNA 7 - Showing every other far DB - Fault! (2011)
RE: Adding headers to email (1997)
Bug Report, maybe (1997)
[username][password] not showing up! HELP! (1999)
[WebDNA] [table] and COMMA in a Field (2015)
Re2: frames & carts (1997)
Pull Down Search (2000)
OFF TOPIC: help wanted (1997)
[WebDNA] Has anyone used 'bootstrap' as their base to create a (2016)
[Sum] function? (1997)
WebDNA Writer Needed (1997)
Date problems (1997)
WebDNA-Talk Digest mode broken (1997)
Searching - FIELDNAMEtype=date FIELDNAMEtype=time (2004)
No answers by SM? (2000)
Slow applescript context ... (2000)
merchant accts. (1997)
Size Options and Multiple prices (2003)
[include] affect on filepaths for links? (1997)
FTP FOLDER PERMISSIONS (2004)