Yeah, so a UNION would work, would this solution be faster than using
a subquery (my instinct says yes) but thought I would ask. They both
execute fast on my system so it's hard to say under load.
Thanks,
Waynn
On 11/12/08, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Nov 12), Way
On Sat, Nov 15, 2008 at 3:54 AM, metastable <[EMAIL PROTECTED]
> wrote:
> I may just have had an insight over my morning coffee.
> How about turning things around and adding a FK -to the customers table-
> on each of the customer type tables (companies, people, charities, etc) ?
>
> The customers
I don't have any links, but in general we don't do very much as far as
tuning is concerned.
Here's a few things I can think of off the top of my head that we
sometimes do if we're worried about performance:
blockdev --setra 2048 /dev/sda (substitute an appropriate readahead
amount and device name
I see that you've already decided on 64-bit anyway, but here's a more
explicit reason to do so: in 32-bit (PAE-mode), no single process can
allocate more than 4GB of memory- that's all the address space there
is. The *system* can see it all, but each process can only work with a
single 4GB chunk of
mysql> CREATE TABLE memberDetails
-> *(*
->memberId INT NOT NULL AUTO_INCREMENT,
->PRIMARY KEY(memberId),
->first_name varchar(100),
->last_name varchar(100),
->Email varchar(60),
->phoneNum varchar(25)
-> *);*
Works withou
I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from
the mysql command shell,
I got an error 1064 (42000): *You have an error in your SQL syntax*;
Here is my code:
mysql> CREATE TABLE memberDetails
-> *(*
->memberId INT NOT NULL AUTO_INCREMENT,
->
www.directoryuniversal.com
Yes, that is the actual daily cost of having your website listed on our
directory. With over 3 million visitors a year coming thru our directory, you
can't afford not to spend the 15 cents a day. Let the professionals at
Universal Real Estate Directory show you how t
I'm running replication between two MySQL servers. This has been working
fine for a while; howver, as of yesterday replication keeps failing because
of a lock wait timeout exceeded on one of my tables.
I thought I could use the mysqlbinlog utility to figure out what queries
were being executed bef
Martijn Tonies wrote:
>> >The notion of a "variant record" exists in many programming languages.
>> >Typically you have a selector to indicate which variant it is. There is
>> >nothing at all wrong with using the same sort of construct in a database
>> >table.
>> >http://en.wikipedia.org/wiki/
