products db philosophy

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39796
interpreted = N
texte = Hello, I'm looking for some advice from the admins here that might have gone through this so I don't have to learn the hard way. (like I usually do)I have a products database. (will be approx a Meg in size or more with the following)In the product db I have a couple short description fields. I also have one larger description field. This field could have text that is maybe up to a paragraph long.The only place this long description will be used is in the product detail area. I am guessing this larger field could tripple the size of our products database. (perhaps 3 megs?)My question is: In your opinion should I separate this portion out to a detail.db?Our Server has plenty of RAM and is a G4 PPC so I am not sure if there will be a speed improvment separating them or not.Thanks in Advance for your comments. -- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics I know I'm making progress when I look at the questions I have asked in the past and think to myself... how stupid was that ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: products db philosophy (Donovan Brooke 2001)
  2. Re: products db philosophy (Andrew Simpson 2001)
  3. Re: products db philosophy (John Peacock 2001)
  4. Re: products db philosophy (Pat McCormick 2001)
  5. products db philosophy (Donovan Brooke 2001)
Hello, I'm looking for some advice from the admins here that might have gone through this so I don't have to learn the hard way. (like I usually do)I have a products database. (will be approx a Meg in size or more with the following)In the product db I have a couple short description fields. I also have one larger description field. This field could have text that is maybe up to a paragraph long.The only place this long description will be used is in the product detail area. I am guessing this larger field could tripple the size of our products database. (perhaps 3 megs?)My question is: In your opinion should I separate this portion out to a detail.db?Our Server has plenty of RAM and is a G4 PPC so I am not sure if there will be a speed improvment separating them or not.Thanks in Advance for your comments. -- Donovan D. Brooke Systems Administrator/ Assc. Art Director Epsen Hillmer Graphics I know I'm making progress when I look at the questions I have asked in the past and think to myself... how stupid was that ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Donovan Brooke

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:

Credit card processing - UK (1997) OFF TOPIC: help wanted (1997) problems with WebCat-Plugin (1997) [WebDNA] Sorting questions (2009) suggestions for a good text editor on windows? (2005) Authenticate (1997) [OT] Airport Network (2003) Custom Error Pages - what I've done (1998) Sendmail problem on UNIX (2000) Um...how do I ask this? (1999) Problems with date math (1997) [CART] (1997) Bug Report, maybe (1997) Re:Transfer of data from Invoice to thank you templates (1998) retail integration (2000) Possible to reset Linux file permissions w/in webcat [shell] ? (2000) Maybe minor bug report (1997) Problem with [Search] inside of [Loop]? (1997) HELP WITH DATES (1997) "Advanced" Search Algorithm (2008)