Re: Is there a max number of fields?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19228
interpreted = N
texte = >Think twice before subdividing your inventory database. Many of the >shopping cart functions depend on looking up things based on the SKUs in >the specified database. If they can pick products from multiple >categories, this would complicate things immensely if you had to figure >out where to get at the data again for lookups, etc. (for invoice pages) >If you could fit all necessary info. in the cart at the beginning (using >textA,B, etc.) fields, maybe this wouldn't be as much an issue.This is not a problem, since it is not an online catalog. It is an old fashioned database. The customer is a large Hotel chain, and they want to put online the data about each hotel (number of rooms, languages spoken, etc, etc, etc, etc, etc, etc, ) and I really mean etc...99.9% of the searches will be made by Hotel code (the SKU).I have not heard on the list of database corruption problems, which is good. But if the DB is split, not all the data will corrupt in case of failure...The advantage of SQL, is that you can search at the same time in two different fields from two different databases.Charles_______________________________________________________________ Institut Balear de Comunicacions, S.L. Gremio Tejedores 22, 1 07009 Palma de Mallorca, Spain _____________________________________________ Tel: +34 971.43.12.77 Fax: +34 971.43.08.18 E-mail: ckefauver@ibacom.es URL: http://www.ibacom.es/ _____________________________________________ Public PGP signature (Clave publica PGP): http://www.ibacom.es/PGP/kefauver.txt _______________________________________________________________
Associated Messages, from the most recent to the oldest:
>Think twice before subdividing your inventory database. Many of the >shopping cart functions depend on looking up things based on the SKUs in >the specified database. If they can pick products from multiple >categories, this would complicate things immensely if you had to figure >out where to get at the data again for lookups, etc. (for invoice pages) >If you could fit all necessary info. in the cart at the beginning (using >textA,B, etc.) fields, maybe this wouldn't be as much an issue.This is not a problem, since it is not an online catalog. It is an old fashioned database. The customer is a large Hotel chain, and they want to put online the data about each hotel (number of rooms, languages spoken, etc, etc, etc, etc, etc, etc, ) and I really mean etc...99.9% of the searches will be made by Hotel code (the SKU).I have not heard on the list of database corruption problems, which is good. But if the DB is split, not all the data will corrupt in case of failure...The advantage of SQL, is that you can search at the same time in two different fields from two different databases.Charles_______________________________________________________________ Institut Balear de Comunicacions, S.L. Gremio Tejedores 22, 1 07009 Palma de Mallorca, Spain _____________________________________________ Tel: +34 971.43.12.77 Fax: +34 971.43.08.18 E-mail: ckefauver@ibacom.es URL: http://www.ibacom.es/ _____________________________________________ Public PGP signature (Clave publica PGP): http://www.ibacom.es/PGP/kefauver.txt _______________________________________________________________
Charles Kefauver
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:
WebCat2b12--[searchstring] bug (1997)
AutoCommit Preference? (1998)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
Browser Problem?!? Still getting Error message using (1997)
Was code to phantom spacing -- now BBEdit [!][/!] (2001)
Windows 2.1b2 Append Bug? (1997)
2.0 Info (1997)
Ok here is a question? (1997)
Deleting Orders (1997)
Running 2 two WebCatalog.acgi's (1996)
setting line item numbers (1998)
Webcatalog error, Plug-in for Webstar (1996)
Authenticating users without dialog box (1997)
Logging purchases (1997)
Copy and paste text into form fields....... (2005)
Old Topic - [OT] - server speeds. (2002)
User/pass with tcpconnect (2000)
[TaxableTotal] - not working with AOL and IE (1997)
Running a store on BOTH http and https (1998)
Bug Report, maybe (1997)