Multiple Querie or Long- Speed

2001-04-13 Thread bryan wheelock
Is a more complex single query going to run faster on a server than several smaller queries where the results are set to variables and then used as criteria in tertiary queries. Bryan - Before posting, please check: http://

Long Query or Multi

2001-04-13 Thread bryan wheelock
Is a more complex single query going to run faster on a server than several smaller queries where the results are set to variables and then used as criteria in tertiary queries. Bryan - Before posting, please check: http://

Question about Open Source DB's

2001-04-04 Thread Bryan Wheelock
I was just wondering, I've been using MySQL and while still a beginner, quite like it. As MySQL is an db engine, how readily would my skills be translatable to PostgeSQL. I have a friend asking me to work on a project with him and he wants to use PostgeSQL and PHP. >From what I've seen the the st

fastest queries

2001-04-04 Thread Bryan Wheelock
I'm working on a MySQL db and I was just curious what type of query was faster. e.g. I have this table1 id (auto# primary key) | date| Name | address | email I want to insert a new name into the DB. Which method would be faster? 1. INSERT INTO table1 VALUES(null,null,'Bryan',null,null); 2. INS

Is email unique?

2001-03-21 Thread Bryan Wheelock
I have been trying to think of naturally occuring unique identifiers that people might use on the internet. I think that e-mail addresses would be a unique way to indentify an individual. Only one e-mail can exist per person. Although an email address could change owners for the most part, each e-

unique identifiers

2001-03-21 Thread Bryan Wheelock
I have been trying to think of naturally occuring unique identifiers that people might use on the internet. I think that e-mail addresses would be a unique way to indentify an individual. Only one e-mail can exist per person. Although an email address could change owners for the most part, each e-

INSERT records into multiple tables

2001-03-16 Thread Bryan Wheelock
I'm just learning how to use MySQL and I am searching for a more simple way of doing an INSERT query into multiple tables simultaneously. I have done my best to nominalize my DB but that creates but I'm confused as to how to insert data into the DB and have all the related table be updated. I thin