Both times seem a bit long, even if you database has millions of rows.
Can you post and explain of your query? That they are in different
databases should have minimal effect on your query.
Brent
On Oct 3, 2008, at 12:14 PM, mos wrote:
I have two indexed MyISAM tables, each in a separate da
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
>Alex K
>Sent: Friday, October 03, 2008 2:15 PM
>To: Mr. Shawn H. Corey
>Cc: Rob Wultsch; mysql@lists.mysql.com
>Subject: Re: simple design choice
>
>That seems like a nice trick. I suppose the flag would
That seems like a nice trick. I suppose the flag would just be an int
and not an enum in this case.
2008/10/3 Mr. Shawn H. Corey <[EMAIL PROTECTED]>:
> On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
>> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote:
>> > Hello,
>> >
>> > I
On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I have a table of a 1 million users. I want to add a flag called
> > delete if a user wants to delete his account. Note that this situation
> > does not happe
Hi,
Personally I would do #3 as well. Have an exact copy (structurally) of
your original table, when the record is deleted then move the account's
details to your deleted_users table so it doesn't appear in users but
you still have all the details.
Not sure if it's possible in MySQL but in
I would do #3.
On 10/3/08, Alex K <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I have a table of a 1 million users. I want to add a flag called
> delete if a user wants to delete his account. Note that this situation
> does not happen a lot.
>
> 1) Should I alter my users table and add a delete fla
I would say providing a table to retain the users relevant details especially
after marking as deleted would be a logical choice
Martin Gainty
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the offic
On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a table of a 1 million users. I want to add a flag called
> delete if a user wants to delete his account. Note that this situation
> does not happen a lot.
>
> 1) Should I alter my users table and add a delete fla
2) is probably cleaner but a hassle as well because one needs to make
sure all user_ids are also in this new table.
2008/10/3 Alex K <[EMAIL PROTECTED]>:
> Hello,
>
> I have a table of a 1 million users. I want to add a flag called
> delete if a user wants to delete his account. Note that this sit
Hello,
I have a table of a 1 million users. I want to add a flag called
delete if a user wants to delete his account. Note that this situation
does not happen a lot.
1) Should I alter my users table and add a delete flag to the users table.
>> it's easy to update however it uses a lot of unnecess
I have two indexed MyISAM tables, each in a separate database. If I do a
left join on the two tables, it takes 2 minutes to return the 5,000 rows.
The same join on similar tables in the same database would take 5-10
seconds. Both databases are on the same drive. So why is it 10x slower when
the
>-Original Message-
>From: Ellison, David [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 03, 2008 2:35 AM
>To: mysql@lists.mysql.com
>Subject: RE: Deployment of Database in a DEB package.
>
>That's true, you would need to consider that risk. Can a DEB package ask
>for information before
Andre, Dave,
Thanks for pointing this out guys. I would certainly like to think about
this and see what the best option is. Dave, we can effectively have the
scripts do anything we like in the DEB package so we could certainly have it
request the username and password from somewhere, either the us
On Thu, Oct 2, 2008 at 1:29 PM, Olaf Stein
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> In my master/salve setup the only database I do not replicate is mysql.
> The slave has only the users absolutely necessary to select and administer,
> that is why a lot of the users I have on the master are not the
14 matches
Mail list logo
