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]