So is karma :)
From: sol beach <[EMAIL PROTECTED]> Reply-To: sol beach <[EMAIL PROTECTED]> To: B Wiley Snyder <[EMAIL PROTECTED]> Subject: Re: MySQL bottleneck Date: Sat, 16 Apr 2005 20:56:08 -0700
Incompetence is its own reward.
Simply put, 360K is NOT a big number or DB given today's hardware.
On 4/16/05, B Wiley Snyder <[EMAIL PROTECTED]> wrote:
> Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I do
> that ! Sorry
>
> >From: [EMAIL PROTECTED]
> >To: "B Wiley Snyder" <[EMAIL PROTECTED]>
> >CC: mysql@lists.mysql.com
> >Subject: Re: MySQL bottleneck
> >Date: Sun, 17 Apr 2005 01:21:36 -0000 (UTC)
> >
> >Hello there,
> >
> >no offence but that questions is not answerable. I wouldnt expect many
> >replies. Let me try to help you out by asking YOU a few questions which
> >might point you into the correct direction:
> >
> >1) Is the data entered once and than mostly read access or is it
> >frequently updated ?
> >
> >2) Do you need transaction support ?
> >
> >3) Do you need the data to be EASY transferable between different OS
> >(MAC/WIN/Unix/Linux) ?
> >
> >BTW: You posted into another thread (which is not good).
> >I suggest you think about the above questions and start a new topic again.
> >
> >Best regards
> >
> >Nils Valentin
> >Tokyo / Japan
> >
> >http://www.be-known-online.com
> >
> >
> > > Hello there, let's say I have 365,000 users I need to enter their data,
> > > pull
> > > from it and modify it regularly. Is MySql the way to go ? Or do I need
> >to
> > > buy an oracle or ms server ?
> > >
> > > thanks in advance for a clue
> > >
> > >>From: [EMAIL PROTECTED]
> > >>To: "B Wiley Snyder" <[EMAIL PROTECTED]>
> > >>CC: mysql@lists.mysql.com
> > >>Subject: Re: How to retain "Key" order when Deleting a Row
> > >>Date: Tue, 12 Apr 2005 14:48:54 -0400
> > >>
> > >>"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12
> > >> PM:
> > >>
> > >> > Hello experts,
> > >> >
> > >> > I just need someone to please point me in the right direction on
> > >>retaining
> > >> > my "key" or id order in my table when I delete a row. So for example
> >I
> > >>have
> > >> > 10 rows Id 1-10 that are created automatically when the record is
> > >>inserted.
> > >> >
> > >> > So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8,9,10
> >but
> > >> > 1,2,3,4,5,6,7,8,9 ???
> > >> >
> > >> >
> > >> > thanks
> > >> >
> > >> > _________________________________________________________________
> > >> > Express yourself instantly with MSN Messenger! Download today - it's
> > >>FREE!
> > >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> > >> >
> > >>
> > >>It sounds like you are confusing a data storage requirement (a unique,
> > >>non-repeating identifier for every row) with a presentation requirement
> > >> (a
> > >>neatly numbered list of records). If I need a nicely ordered list of
> > >>numbers, I use my programming language to provide it. If I need to
> > >>uniquely identify a record, I use the ID.
> > >>
> > >>When an ID has been issued, it generally stays "used" even if that
> >record
> > >>no longer exists.
> > >>
> > >>
> > >>Shawn Green
> > >>Database Administrator
> > >>Unimin Corporation - Spruce Pine
> > >
> > > _________________________________________________________________
> > > Express yourself instantly with MSN Messenger! Download today - it's
> >FREE!
> > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > >
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe:
> >http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
