Re: DB Size - MAX
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57074
interpreted = N
texte = I had an 80MB web log where I performed date based searched in WebDNA. It got a little sluggish because I didn't store the dates in the numerical format that has been recommended. I find date searching to be somewhat troublesome anyway, unless I search for a specific date and treat the field as text. Other than that, I've not come close to an upper limit, although, it'd be nice to know what it is. Bill -----Original Message----- From: Brian Boegershausen
Sent: Wed, 24 Mar 2004 10:26:54 -0500 To: (WebDNA Talk) Subject: DB Size - MAX So far, I have to give kudos to SM. I have a DB that is 31mb and growing by the day. No problems with it. The DB is searched and added to thousands of times everyday and as of a few minutes ago has 214000 records in it. My clients server is a Dell 8450 8 x 700mhz Xeon Processors 8 gigs of RAM Dual RAID5 SCSI HD setups. Running Win2k Adv WebDNA 4.51 I was wondering what is the largest DB someone has had on their site and did they ever have any problems. Lately I have been playing with the new SQL features of 6.0 on my own server and have been very happy. This site is on a different server and does not have 6.0, but I may see about upgrading my clients machine. Brian Boegershausen ------------------------------------------------------------- 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I had an 80MB web log where I performed date based searched in WebDNA. It got a little sluggish because I didn't store the dates in the numerical format that has been recommended. I find date searching to be somewhat troublesome anyway, unless I search for a specific date and treat the field as text. Other than that, I've not come close to an upper limit, although, it'd be nice to know what it is. Bill -----Original Message----- From: Brian Boegershausen Sent: Wed, 24 Mar 2004 10:26:54 -0500 To: (WebDNA Talk) Subject: DB Size - MAX So far, I have to give kudos to SM. I have a DB that is 31mb and growing by the day. No problems with it. The DB is searched and added to thousands of times everyday and as of a few minutes ago has 214000 records in it. My clients server is a Dell 8450 8 x 700mhz Xeon Processors 8 gigs of RAM Dual RAID5 SCSI HD setups. Running Win2k Adv WebDNA 4.51 I was wondering what is the largest DB someone has had on their site and did they ever have any problems. Lately I have been playing with the new SQL features of 6.0 on my own server and have been very happy. This site is on a different server and does not have 6.0, but I may see about upgrading my clients machine. Brian Boegershausen ------------------------------------------------------------- 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://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/
devaulw@onebox.com
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:
Sorting Date (2004)
ssl/empty cart problem (2003)
Running _every_ page through WebCat ? (1997)
Spiders and Bots (2000)
Where is f2? (1997)
Re:Off Topic: Frames Killer? (1998)
Searching multiple Databases (1997)
PIXO (1997)
Search syntax question (1998)
Plugin or CGI or both (1997)
WebStar Secure on other machine (1997)
SOP for WebDNA talk - MSNBot Crashing (2004)
customers getting same cart (2004)
ImageMagick on OSX (2003)
Upgrading old WebCat Database Files (1997)
Re2: frames & carts (1997)
WC Host List (2000)
[WebDNA] group searching not working as expected. (2010)
[template] tag (1998)
Cart questions (1997)