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:
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:
Updating Prices in Online Database (1999)
Req: Row DB feature (2004)
Re:Virtual hosting and webcatNT (1997)
Which GUI HTML editors work with WC ? (1997)
Frames (1997)
proper username/password *w/out* the authenticate dialog. (2000)
Fun with dates (1997)
Mail Service Dead (1998)
formvars available in formulas.db? (2000)
[WebDNA] WebDNA and Google Geo Tagging (2012)
Help formatting search results w/ table (1997)
Mixing and/or in searches (1998)
[OT]Co-Location of a Server (2002)
How To question on setting up downloads (1997)
Search Philosophy (2001)
Running webcat 6 on Windows XP Prof. (2005)
Server IP address? (1998)
Lost Field (1998)
shipCost not working v2.1b4 (1997)
Nested tags count question (1997)