RE: Database Question???
Keep them in one table. What you should have is one table which holds user information which you can use to log people in. Then create other tables to store relevant info on them. For example. I have a table which store username, password, + general details of user. I then have a table called education and a table called work. These tables hold all of the users educational history and work experiences reapectively and can ghold many records for each user. If you have a table per user your database would feasible have hundreds/thousands of tables with only one record in each! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: 06 November 2000 14:54 To: CF-Talk Subject: Database Question??? I am setting up a website in which people are creating records and storing them in a database (Access 2000 at this time). Am I better off with a single table that includes all of the records of all users or should I set up a seperate table for each user? I am pretty sure that the seperate tables would have better performance but will probably be harder to upgrade to SQL 7 later. Please let me know your opinions. Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Database Question???
Just use one table. Your application will be difficult to code & maintain otherwise. I don't think there's any performance benefit from using multiple tables. Nick -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 2:54 PM To: CF-Talk Subject: Database Question??? I am setting up a website in which people are creating records and storing them in a database (Access 2000 at this time). Am I better off with a single table that includes all of the records of all users or should I set up a seperate table for each user? I am pretty sure that the seperate tables would have better performance but will probably be harder to upgrade to SQL 7 later. Please let me know your opinions. Thanks, Rich ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Database Question???
I have a similar structure in my database where advertisers can create their own ads on my accommodation website. I have 7 different categories of advertisers on my site eg: accommodation businesses; tourist attraction businesses; local transport businesses etc Each advertiser chooses their specific category and then their ad is added to that specific categories table I have recently upgraded to sql7.0 and there has been no problems using the structure indicated above. Please feel free to visit my website www.australianaccommodation.com to view the functionality of the site. Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com - Original Message - From: "ibtoad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 07, 2000 12:53 AM Subject: Database Question??? I am setting up a website in which people are creating records and storing them in a database (Access 2000 at this time). Am I better off with a single table that includes all of the records of all users or should I set up a seperate table for each user? I am pretty sure that the seperate tables would have better performance but will probably be harder to upgrade to SQL 7 later. Please let me know your opinions. Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Database Question???
A single table with a column for "user" is much better. Put an index on the "user" column to speed it up. If you created new tables for each user you would have to alter your database (create table and drop table) for every new user and deleted user. You would have to come up with a naming scheme for all these tables so there are no name collisions. At 09:53 AM 11/6/00 -0500, ibtoad wrote: >I am setting up a website in which people are creating records and storing >them in a database (Access 2000 at this time). Am I better off with a >single table that includes all of the records of all users or should I set >up a seperate table for each user? I am pretty sure that the seperate >tables would have better performance but will probably be harder to upgrade >to SQL 7 later. Please let me know your opinions. > > >Thanks, >Rich > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message >with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Database Question???
Each user will have many records, that is why I thought it would be better to have multiple tables. Otherwise I will wind up with one table that may have thousands of records. 100 users with 100 records each is 10,000 records. This will really slow down the performance right? Rich -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 10:13 AM To: CF-Talk Subject: RE: Database Question??? Keep them in one table. What you should have is one table which holds user information which you can use to log people in. Then create other tables to store relevant info on them. For example. I have a table which store username, password, + general details of user. I then have a table called education and a table called work. These tables hold all of the users educational history and work experiences reapectively and can ghold many records for each user. If you have a table per user your database would feasible have hundreds/thousands of tables with only one record in each! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: 06 November 2000 14:54 To: CF-Talk Subject: Database Question??? I am setting up a website in which people are creating records and storing them in a database (Access 2000 at this time). Am I better off with a single table that includes all of the records of all users or should I set up a seperate table for each user? I am pretty sure that the seperate tables would have better performance but will probably be harder to upgrade to SQL 7 later. Please let me know your opinions. Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Database Question???
I agree with Andy. You should invest in a SQL book like "SQL Queries for Mere Mortals"(has a great section on database structure) or Ben Forta's "SQL in 10 Minutes" (ISBN 0-672-31664-1) for $12.99. It serves as a great reference and teaches you the basics in a concise manner. To add to what Andy said...you should also create primary keys for each table you create and relate the tables through these keys. Shane Witbeck www.digitalsanctum.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 10:13 AM To: CF-Talk Subject: RE: Database Question??? Keep them in one table. What you should have is one table which holds user information which you can use to log people in. Then create other tables to store relevant info on them. For example. I have a table which store username, password, + general details of user. I then have a table called education and a table called work. These tables hold all of the users educational history and work experiences reapectively and can ghold many records for each user. If you have a table per user your database would feasible have hundreds/thousands of tables with only one record in each! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: 06 November 2000 14:54 To: CF-Talk Subject: Database Question??? I am setting up a website in which people are creating records and storing them in a database (Access 2000 at this time). Am I better off with a single table that includes all of the records of all users or should I set up a seperate table for each user? I am pretty sure that the seperate tables would have better performance but will probably be harder to upgrade to SQL 7 later. Please let me know your opinions. Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Database Question???
10,000 records shouldn't slow down performance although I've never really used Access. Managing tables would be infinitely harder. If performance does become a problem upgrade hardware and/or the db to SQL Server or something similar. Duncan Hays Peace Corps -Original Message- From: Auction Hard Drive [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 11:25 AM To: CF-Talk Cc: [EMAIL PROTECTED] Subject: RE: Database Question??? Each user will have many records, that is why I thought it would be better to have multiple tables. Otherwise I will wind up with one table that may have thousands of records. 100 users with 100 records each is 10,000 records. This will really slow down the performance right? Rich -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 10:13 AM To: CF-Talk Subject: RE: Database Question??? Keep them in one table. What you should have is one table which holds user information which you can use to log people in. Then create other tables to store relevant info on them. For example. I have a table which store username, password, + general details of user. I then have a table called education and a table called work. These tables hold all of the users educational history and work experiences reapectively and can ghold many records for each user. If you have a table per user your database would feasible have hundreds/thousands of tables with only one record in each! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: 06 November 2000 14:54 To: CF-Talk Subject: Database Question??? I am setting up a website in which people are creating records and storing them in a database (Access 2000 at this time). Am I better off with a single table that includes all of the records of all users or should I set up a seperate table for each user? I am pretty sure that the seperate tables would have better performance but will probably be harder to upgrade to SQL 7 later. Please let me know your opinions. Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Database Question???
So? What's wrong with one table having thousands of records? That's what a database is built for. One table, lots of records. To speed it up put an index on the key that you are using to select records. At 11:24 AM 11/6/00 -0500, Auction Hard Drive wrote: >Each user will have many records, that is why I thought it would be better >to have multiple tables. Otherwise I will wind up with one table that may >have thousands of records. 100 users with 100 records each is 10,000 >records. This will really slow down the performance right? > >Rich > >-Original Message- >From: Andy Ewings [mailto:[EMAIL PROTECTED]] >Sent: Monday, November 06, 2000 10:13 AM >To: CF-Talk >Subject: RE: Database Question??? > > >Keep them in one table. > >What you should have is one table which holds user information which you can >use to log people in. Then create other tables to store relevant info on >them. For example. I have a table which store username, password, + >general details of user. I then have a table called education and a table >called work. These tables hold all of the users educational history and >work experiences reapectively and can ghold many records for each user. > >If you have a table per user your database would feasible have >hundreds/thousands of tables with only one record in each! > >-- >Andrew Ewings >Project Manager >Thoughtbubble Ltd >http://www.thoughtbubble.net >-- >United Kingdom >http://www.thoughtbubble.co.uk/ >Tel: +44 (0) 20 7387 8890 >-- >New Zealand >http://www.thoughtbubble.co.nz/ >Tel: +64 (0) 9 419 4235 >-- >The information in this email and in any attachments is confidential and >intended solely for the attention and use of the named addressee(s). Any >views or opinions presented are solely those of the author and do not >necessarily represent those of Thoughtbubble. This information may be >subject to legal, professional or other privilege and further distribution >of it is strictly prohibited without our authority. If you are not the >intended recipient, you are not authorised to disclose, copy, distribute, or >retain this message. Please notify us on +44 (0)207 387 8890. > > > >-Original Message- >From: ibtoad [mailto:[EMAIL PROTECTED]] >Sent: 06 November 2000 14:54 >To: CF-Talk >Subject: Database Question??? > > >I am setting up a website in which people are creating records and storing >them in a database (Access 2000 at this time). Am I better off with a >single table that includes all of the records of all users or should I set >up a seperate table for each user? I am pretty sure that the seperate >tables would have better performance but will probably be harder to upgrade >to SQL 7 later. Please let me know your opinions. > > >Thanks, >Rich > > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a >message with 'unsubscribe' in the body to [EMAIL PROTECTED] > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a >message with 'unsubscribe' in the body to [EMAIL PROTECTED] > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message >with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Database Question???
I'd stick with a solid schema as opposed to trying to gain speed by chopping up your database design. There are other areas you can gain speed (for example, stick queries in memory, my personal favorite) without sacrificing quality of code. -- Billy Cravens [EMAIL PROTECTED] Auction Hard Drive wrote: > > Each user will have many records, that is why I thought it would be better > to have multiple tables. Otherwise I will wind up with one table that may > have thousands of records. 100 users with 100 records each is 10,000 > records. This will really slow down the performance right? > > Rich > > -Original Message- > From: Andy Ewings [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 06, 2000 10:13 AM > To: CF-Talk > Subject: RE: Database Question??? > > Keep them in one table. > > What you should have is one table which holds user information which you can > use to log people in. Then create other tables to store relevant info on > them. For example. I have a table which store username, password, + > general details of user. I then have a table called education and a table > called work. These tables hold all of the users educational history and > work experiences reapectively and can ghold many records for each user. > > If you have a table per user your database would feasible have > hundreds/thousands of tables with only one record in each! > > -- > Andrew Ewings > Project Manager > Thoughtbubble Ltd > http://www.thoughtbubble.net > -- > United Kingdom > http://www.thoughtbubble.co.uk/ > Tel: +44 (0) 20 7387 8890 > -- > New Zealand > http://www.thoughtbubble.co.nz/ > Tel: +64 (0) 9 419 4235 > -- > The information in this email and in any attachments is confidential and > intended solely for the attention and use of the named addressee(s). Any > views or opinions presented are solely those of the author and do not > necessarily represent those of Thoughtbubble. This information may be > subject to legal, professional or other privilege and further distribution > of it is strictly prohibited without our authority. If you are not the > intended recipient, you are not authorised to disclose, copy, distribute, or > retain this message. Please notify us on +44 (0)207 387 8890. > > -Original Message- > From: ibtoad [mailto:[EMAIL PROTECTED]] > Sent: 06 November 2000 14:54 > To: CF-Talk > Subject: Database Question??? > > I am setting up a website in which people are creating records and storing > them in a database (Access 2000 at this time). Am I better off with a > single table that includes all of the records of all users or should I set > up a seperate table for each user? I am pretty sure that the seperate > tables would have better performance but will probably be harder to upgrade > to SQL 7 later. Please let me know your opinions. > > Thanks, > Rich > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a > message with 'unsubscribe' in the body to [EMAIL PROTECTED] > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a > message with 'unsubscribe' in the body to [EMAIL PROTECTED] > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message >with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Database Question???
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C04845.E43A68E0 Content-Type: text/plain; charset="iso-8859-1" You could try the book Database design for mere mortals. its a great book to learn DB relationships. Shawn Regan [EMAIL PROTECTED] Cold Fusion Developer Pacific Technology Solutions --_=_NextPart_001_01C04845.E43A68E0 Content-Type: text/html; charset="iso-8859-1" RE: Database Question??? You could try the book Database design for mere mortals. its a great book to learn DB relationships. Shawn Regan [EMAIL PROTECTED] Cold Fusion Developer Pacific Technology Solutions --_=_NextPart_001_01C04845.E43A68E0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Database Question???
I have an access (2000) table with 75 000 records. More of an experiment than anything I guess, but it seems to be holding up ok. I am using it to store all the IP numbers of visitors, then I do a select distinct IP by day, and spit out a list of pages people looked at. Suprisingly, it works ok. I can usually get 2 000 records returned in about twenty seconds Overkill for an access dbase, but I thought I'd just let it roll till it blew up still alive : ) Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Database question.
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF9A8A.CB93F920 Content-Type: text/plain; charset="iso-8859-1" Microsoft clearly explains that Access is really a development database and should not be used when there are more than a few users. I can give you the link on Microsoft's web site if you like. I'd go with MS SQL. Its fairly easy to use when compared with other databases like Oracle. Daniel Bogesdorfer Programmer/Analyst RSL COM USA INC Voice 412.244.6628 -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 30, 2000 3:48 PM To: '[EMAIL PROTECTED]' Subject: Database question. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/plain; charset="iso-8859-1" Hey guys, I need to know how much an Access database can handle, like hits per hour type of information. I need to know when I build an application which database I can use. Access or MS SQL. If anyone has any docs or sites that state this type of information, please let me know. TIA Shawn Regan --_=_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Database question. Hey guys, I need to know how much an Access database can = handle, like hits per hour type of information. I need to know when I = build an application which database I can use. Access or MS SQL. If = anyone has any docs or sites that state this type of information, = please let me know. TIA Shawn Regan --_=_NextPart_001_01BF9A89.3FBB16A0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BF9A8A.CB93F920 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Database question. Microsoft clearly explains that Access is really a = development database and should not be used when there are more than a = few users. I can give you the link on Microsoft's web site if you = like. I'd go with MS SQL. Its fairly easy to use when = compared with other databases like Oracle. Daniel Bogesdorfer Programmer/Analyst RSL COM USA INC Voice 412.244.6628 -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] Sent: Thursday, March 30, 2000 3:48 PM To: '[EMAIL PROTECTED]' Subject: Database question. This message is in MIME format. Since your mail = reader does not understand this format, some or all of this message may not be = legible. --_=3D_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/plain; charset=3D"iso-8859-1" Hey guys, I need to know how much an Access database can = handle, like hits per hour type of information. I need to know when I build an = application which database I can use. Access or MS SQL. If anyone has = any docs or sites that state this type of information, please let me = know. TIA Shawn Regan --_=3D_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/html; charset=3D"iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML = 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D3D"Content-Type" = CONTENT=3D3D"text/html; =3D charset=3D3Diso-8859-1"> <META NAME=3D3D"Generator" = CONTENT=3D3D"MS Exchange Server version =3D 5.5.2650.12"> <TITLE>Database question.</TITLE> </HEAD> <BODY> <BR> <P><FONT SIZE=3D3D2>Hey = guys,</FONT> </P> <P><FONT SIZE=3D3D2>I need to know how = much an Access database can =3D handle, like hits per hour type of information. I = need to know when I =3D build an application which database I can use. = Access or MS SQL. If =3D anyone has any docs or sites that state this type of = information, =3D please let me know.</FONT></P> <P><FONT = SIZE=3D3D2>TIA</FONT> <BR><FONT SIZE=3D3D2>Shawn = Regan</FONT> </P> </BODY> </HTML> --_=3D_NextPart_001_01BF9A89.3FBB16A0-- ---= --- Archives: http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= st
RE: Database question.
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF9A90.FF573FE0 Content-Type: text/plain; charset="iso-8859-1" Yes please send me the link to the doc on MS. Shawn Regan -Original Message- From: Bogesdorfer, Dan L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 30, 2000 12:59 PM To: '[EMAIL PROTECTED]' Subject: RE: Database question. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF9A8A.CB93F920 Content-Type: text/plain; charset="iso-8859-1" Microsoft clearly explains that Access is really a development database and should not be used when there are more than a few users. I can give you the link on Microsoft's web site if you like. I'd go with MS SQL. Its fairly easy to use when compared with other databases like Oracle. Daniel Bogesdorfer Programmer/Analyst RSL COM USA INC Voice 412.244.6628 -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 30, 2000 3:48 PM To: '[EMAIL PROTECTED]' Subject: Database question. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/plain; charset="iso-8859-1" Hey guys, I need to know how much an Access database can handle, like hits per hour type of information. I need to know when I build an application which database I can use. Access or MS SQL. If anyone has any docs or sites that state this type of information, please let me know. TIA Shawn Regan --_=_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Database question. Hey guys, I need to know how much an Access database can = handle, like hits per hour type of information. I need to know when I = build an application which database I can use. Access or MS SQL. If = anyone has any docs or sites that state this type of information, = please let me know. TIA Shawn Regan --_=_NextPart_001_01BF9A89.3FBB16A0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BF9A8A.CB93F920 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Database question. Microsoft clearly explains that Access is really a = development database and should not be used when there are more than a = few users. I can give you the link on Microsoft's web site if you = like. I'd go with MS SQL. Its fairly easy to use when = compared with other databases like Oracle. Daniel Bogesdorfer Programmer/Analyst RSL COM USA INC Voice 412.244.6628 -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] Sent: Thursday, March 30, 2000 3:48 PM To: '[EMAIL PROTECTED]' Subject: Database question. This message is in MIME format. Since your mail = reader does not understand this format, some or all of this message may not be = legible. --_=3D_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/plain; charset=3D"iso-8859-1" Hey guys, I need to know how much an Access database can = handle, like hits per hour type of information. I need to know when I build an = application which database I can use. Access or MS SQL. If anyone has = any docs or sites that state this type of information, please let me = know. TIA Shawn Regan --_=3D_NextPart_001_01BF9A89.3FBB16A0 Content-Type: text/html; charset=3D"iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML = 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D3D"Content-Type" = CONTENT=3D3D"text/html; =3D charset=3D3Diso-8859-1"> <META NAME=3D3D"Generator" = CONTENT=3D3D"MS Exchange Server version =3D 5.5.2650.12"> <TITLE>Database question.</TITLE> </HEAD> <BODY> <BR> <P><FONT SIZE=3D3D2>Hey = guys,</FONT> </P> <P><FONT SIZE=3D3D2>I need to know how = much an Access database can =3D handle, like hits per hour type of information. I = need to know when I =3D build an application which database I can use. = Access or MS SQL. If =3D anyone has any docs or sites that state this type of = information, =3D please let me know.</FONT></P&
Re: Database question.
Shawn, Just stay away from Access. You will start out with access fine, but will have to move to SQL later. lol Jacob At 12:48 PM 3/30/00 -0800, you wrote: >This message is in MIME format. Since your mail reader does not understand >this format, some or all of this message may not be legible. > >--_=_NextPart_001_01BF9A89.3FBB16A0 >Content-Type: text/plain; > charset="iso-8859-1" > > >Hey guys, > >I need to know how much an Access database can handle, like hits per hour >type of information. I need to know when I build an application which >database I can use. Access or MS SQL. If anyone has any docs or sites that >state this type of information, please let me know. > >TIA >Shawn Regan > >--_=_NextPart_001_01BF9A89.3FBB16A0 >Content-Type: text/html; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > > >Database question. > >Hey guys, > >I need to know how much an Access database can = handle, like hits per >hour type of information. I need to know when I = build an application >which database I can use. Access or MS SQL. If = anyone has any docs or >sites that state this type of information, = please let me know. > >TIA >Shawn Regan >--_=_NextPart_001_01BF9A89.3FBB16A0-- >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Database Question
I think you're looking for: INSERT INTO MtTable3 (ID) SELECT ID FROM MyTable1 WHERE SpecialID=3 It's as simple as that, Bob -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 8:32 PM To: CF-Talk Subject: OT: Database Question Fellow Listers! All the talk about @@identity encouraged me to ask this question: Say I: UPDATE Table2 SET City = 'Oakland' WHERE ID IN (SELECT ID FROM MyTable1 WHERE SpecialID = 3) This is done all within SQL7, and SELECT ID FROM MyTable1 WHERE SpecialID = 3 is a comma-delimited list of IDs. How would I do the case where I have Table3 with one column, and I wanted to INSERT the IDs in it from: SELECT ID FROM MyTable1 WHERE SpecialID=3 one ID per row, all within SQL7 (no CFAS)? best, paul == N: Paul Smith, Web/Database Droid A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611 (There, there, there; there's, there, there) P: (510) 763-2358 _o C: (510) 205-6755 _\<,_ F: (510) 763-2370 (_)/(_) E: [EMAIL PROTECTED] W: http://www.support.net "The sun, with all those planets revolving around it and dependent on it, can still ripen a bunch of grapes as if it had nothing else to do." --Galileo ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question
Thanks! best, paul At 09:26 PM 3/20/01 -0500, you wrote: >I think you're looking for: > >INSERT INTO MtTable3 (ID) >SELECT ID FROM MyTable1 WHERE SpecialID=3 > >It's as simple as that, >Bob ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question
There is no one-line SQL statement that will do that. You would use some looping structure if you were passing in a list of IDs, but if this is all occurring in the same batch, you can select your values into a temp table, then use an INSERTSELECT statement to insert based on your tempTable values. SELECT ID INTO #myTemp FROM myTable1 WHERE SpecialID = 3 INSERT INTO table3 (ID) SELECT ID from #myTemp Check your SQL 7 help for more info on SELECT INTO and INSERT...SELECT. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 7:32 PM To: CF-Talk Subject: OT: Database Question Fellow Listers! All the talk about @@identity encouraged me to ask this question: Say I: UPDATE Table2 SET City = 'Oakland' WHERE ID IN (SELECT ID FROM MyTable1 WHERE SpecialID = 3) This is done all within SQL7, and SELECT ID FROM MyTable1 WHERE SpecialID = 3 is a comma-delimited list of IDs. How would I do the case where I have Table3 with one column, and I wanted to INSERT the IDs in it from: SELECT ID FROM MyTable1 WHERE SpecialID=3 one ID per row, all within SQL7 (no CFAS)? best, paul == N: Paul Smith, Web/Database Droid A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611 (There, there, there; there's, there, there) P: (510) 763-2358 _o C: (510) 205-6755 _\<,_ F: (510) 763-2370 (_)/(_) E: [EMAIL PROTECTED] W: http://www.support.net "The sun, with all those planets revolving around it and dependent on it, can still ripen a bunch of grapes as if it had nothing else to do." --Galileo ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database Question??
Umm . . . why does each store need its own sales tax rate for each state? Does the sales tax vary from store to store? Scott - Scott Brady http://www.scottbrady.net/ - Original Message - From: "Rich Tretola" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 9:33 PM Subject: Database Question?? > I would like to run multiple stores through the same database. This is why > I added the a storeid field making the fields State, TaxRate, StoreID. The > only problem is that I would need to add 51 records for each store I add. > Does anyone have a better idea on how I could setup this table? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question??
Hi Scott - I think it could vary from store to store - because in some states the sales tax varies from county to county. I know in CA the rate varies depending on where the business is located. (Or, at least, I think it works like this. I could be mistaken). Jay -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:34 PM To: CF-Talk Subject: Re: Database Question?? Umm . . . why does each store need its own sales tax rate for each state? Does the sales tax vary from store to store? Scott - Scott Brady http://www.scottbrady.net/ - Original Message - From: "Rich Tretola" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 9:33 PM Subject: Database Question?? > I would like to run multiple stores through the same database. This > is why > I added the a storeid field making the fields State, TaxRate, StoreID. The > only problem is that I would need to add 51 records for each store I > add. Does anyone have a better idea on how I could setup this table? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database Question??
Well, it seems like you would only have 2 circumstances for each store's orders, right? 1) The person is ordering from the state where the store is located, so they get that store's specific rate. 2) The person is ordering from another state, so they would only pay the regular state rate. Is that right? If that's so, you could have one table with 51 records which would be your "Regular State Rate" table. Every time someone orders from a different state, you'd use the regular rate. Another table could have the unique rates for each store/state combination for when an in-state customer is ordering. I'm not sure if that makes sense or not. It does in my head. Scott - Scott Brady http://www.scottbrady.net/ - Original Message - From: "Jay Sudowski - Handy Networks LLC" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 9:45 PM Subject: RE: Database Question?? > Hi Scott - > > I think it could vary from store to store - because in some states the > sales tax varies from county to county. I know in CA the rate varies > depending on where the business is located. (Or, at least, I think it > works like this. I could be mistaken). > > Jay > > -Original Message- > From: Scott Brady [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 11:34 PM > To: CF-Talk > Subject: Re: Database Question?? > > > Umm . . . why does each store need its own sales tax rate for each > state? Does the sales tax vary from store to store? > > Scott > - > Scott Brady > http://www.scottbrady.net/ > - Original Message - > From: "Rich Tretola" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 18, 2001 9:33 PM > Subject: Database Question?? > > > > I would like to run multiple stores through the same database. This > > is > why > > I added the a storeid field making the fields State, TaxRate, StoreID. > The > > only problem is that I would need to add 51 records for each store I > > add. Does anyone have a better idea on how I could setup this table? > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database Question??
Jay, CA sales tax does vary by county, The Board of Equalization's site explaining it all is here: http://www.boe.ca.gov/pam71.htm I have clients who researched this directly and reported back that they only have to charge tax based on their origin point. However the current BOE data seems to contradict this at first glance. Looks like they want tax charged based on buyer origin. I have no clue what other states do about this, but it sounds like quite a nasty little app to have to write. Am I wrong or do you only have to charge sales tax if the buyer is in the same state as the seller (where ''in the same state'' is defined as *all* physical premises the seller may have in the all states). --Matt-- - Original Message - From: "Jay Sudowski - Handy Networks LLC" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 8:45 PM Subject: RE: Database Question?? Hi Scott - I think it could vary from store to store - because in some states the sales tax varies from county to county. I know in CA the rate varies depending on where the business is located. (Or, at least, I think it works like this. I could be mistaken). Jay -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:34 PM To: CF-Talk Subject: Re: Database Question?? Umm . . . why does each store need its own sales tax rate for each state? Does the sales tax vary from store to store? Scott - Scott Brady http://www.scottbrady.net/ - Original Message - From: "Rich Tretola" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 9:33 PM Subject: Database Question?? > I would like to run multiple stores through the same database. This > is why > I added the a storeid field making the fields State, TaxRate, StoreID. The > only problem is that I would need to add 51 records for each store I > add. Does anyone have a better idea on how I could setup this table? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question
Triggers, by definition, aren't called by CF, they are automatically triggered when an action occurs on a table in your db (Insert,update,delete) so you can't pass data back as CF didn't initiate the trigger -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: 19 July 2001 15:01 To: CF-Talk Subject: Database Question hey guys, I'm working with triggers, how do i make the variable in the trigger pass the data back to CF? do i need a COM object or somthing? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question
> hey guys, I'm working with triggers, how do i make the > variable in the trigger pass the data back to CF? do i > need a COM object or somthing? You can simply return a resultset by building a SELECT within the trigger. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question
Dave I don't follow this...can you further explain. If you can't call a trigger form within CF (as it is fires automatically by the DB when a specific action occurs on a table) then how do you get it to return the data to CF? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 19 July 2001 16:01 To: CF-Talk Subject: RE: Database Question > hey guys, I'm working with triggers, how do i make the > variable in the trigger pass the data back to CF? do i > need a COM object or somthing? You can simply return a resultset by building a SELECT within the trigger. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question
> I don't follow this...can you further explain. If you can't > call a trigger form within CF (as it is fires automatically by > the DB when a specific action occurs on a table) then how do > you get it to return the data to CF? That's the beauty of it - it'll do it automatically. If you insert a record into a table, and that table has an insert trigger that returns a recordset, you'll get that recordset back in CF - it'll be stored in the query object named by the CFQUERY tag that did the insert. For example, you can return an identity column value from a trigger. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists