Re: large database
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27171
interpreted = N
texte = A database with 1.5 million records is a pretty good size, but with some smart coding you should be able to get performance into the VERY reasonable category. Since the database is only updated every two weeks, I'd recommend a pre-indexing or splitting of the database. You could probably hack together a pretty good solution using the first generation ZipBurst Product (which includes the ZipBurst Generator) or we could think about a high performance custom build with a little bit of intelligence that caters to your specific needs.David Dantowitz -- DC&R>Check into ZipServe and ZipBurst from David Dantowitz > >http://www.dantowitz.com/ > > >At 9:09 AM 2/4/00, Joe Wilkins wrote: >>> We're looking at setting up a Web search/locator that will allow people to >>> choose one of our products and enter their zip code, city, state, etc. and >>> search for a store that carries that product. The database file will be >>> updated every two weeks with info from IRI (the supermarket scanner data >>> people). The database will be about 1.5 million records. Each record will be >>> product name, store name and address, and a yes/no field. Has anyone used a >>> database this large with WebCat? >>> >>> I know I could break it into smaller regional databases if necessary. One of >>> our competitors has a similar page, but it sometimes takes minutes to return >>> any data. We want a much faster response. >>> >>> Joe Wilkins >>> webmaster@benjerry.com >>> joe@mercury.benjerry.com------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
A database with 1.5 million records is a pretty good size, but with some smart coding you should be able to get performance into the VERY reasonable category. Since the database is only updated every two weeks, I'd recommend a pre-indexing or splitting of the database. You could probably hack together a pretty good solution using the first generation ZipBurst Product (which includes the ZipBurst Generator) or we could think about a high performance custom build with a little bit of intelligence that caters to your specific needs.David Dantowitz -- DC&R>Check into ZipServe and ZipBurst from David Dantowitz > >http://www.dantowitz.com/ > > >At 9:09 AM 2/4/00, Joe Wilkins wrote: >>> We're looking at setting up a Web search/locator that will allow people to >>> choose one of our products and enter their zip code, city, state, etc. and >>> search for a store that carries that product. The database file will be >>> updated every two weeks with info from IRI (the supermarket scanner data >>> people). The database will be about 1.5 million records. Each record will be >>> product name, store name and address, and a yes/no field. Has anyone used a >>> database this large with WebCat? >>> >>> I know I could break it into smaller regional databases if necessary. One of >>> our competitors has a similar page, but it sometimes takes minutes to return >>> any data. We want a much faster response. >>> >>> Joe Wilkins >>> webmaster@benjerry.com >>> joe@mercury.benjerry.com------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
David M. Dantowitz
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:
Looking for 5 to 12 shops with 3 URLs & statements (1997)
Guestbook (2000)
PCS search results page (1998)
deadlock (2000)
PCS Emailer's role ? (1997)
Dismissing dialogs (was 2.1b3 --> way slow) (1997)
WebDNA on OS X Tiger (2006)
I'm new be kind (1997)
Emailer.Out (1998)
Extended [ConvertChars] (1997)
Up and running ... at last !! (1997)
SKU lookup (1997)
Resetting a Formvariable (2000)
flushdatabases (2000)
v5.x and Apache 2.x (2003)
forming a SKU (1999)
RequiredFields template (1997)
$Append for Users outside the ADMIN group (1997)
refreshing IE with posted .tmpl (1997)
[Announce]: Web server security and password protection (1997)