Re: [ilugd]: MySQL evaluation

2002-05-02 Thread amit soni
> > supports is better memory management? > Last time i checked, MySQL didn't hav any built in caching algorithm. That > was 3.22.xx version series. For disk caching MySQL depends on the OS, and Was in their todo list in last year, should be done by now. So using OS cache is not as good as havin

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread amit soni
Think u read it all rong. The car drivers are the database engine. Computer hardware is the car. now? > > The shortest road between two points is a straight line.The person driving > > on the zig-zag road will always loose. > > Even if he is a much better driver, he has those extra turns to hand

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Lokesh Bhog
> Well, actually the difference is that the hardware > are not same... Both may be car's but > the engines are different. You can't compare a > ferrari engine with fiat palio's engine! > Though both burn fuel and rotate a shaft. Those > '1999' other things that go into ferrari > engine makes the d

RE: [ilugd]: MySQL evaluation

2002-05-02 Thread D.Venkatasubramanian, Noida
Hi, I don't see where this discussion is headed. The basic difference between Oracle and mySQL would be in the area of Query Optimization. Probably, this is the most critical phase which distinguishes from one DBMS to other. And Oracle has a wonderful Query Optimizer. Query Optimization is a ver

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Sanjeev Gupta
- Original Message - From: "amit soni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, 02 May, 2002 1:56 AM Subject: Re: [ilugd]: MySQL evaluation > > > Maybe one of the 2000 is a querry optimiser? Or one of the "many things" > it > OK accepted, perhaps sub queries make thi

Re: [ilugd]: modem causing problem ?

2002-05-02 Thread Ambar Roy
> Perhaps we can help you if you can provide more details about the modem and > error. > AB > i m trying to connect to the Internet and the modem is dialed properly > by AB > kppp, but gives an error with status 16 or 19. > AB > i m using RedHat 7.2 I hav a feeling that this is a pppd error, the

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Ambar Roy
Hi, > Do triggers, trans, foreign keys and rest 1996 things etc also improve speed > ? a lot of things improve performence, if used properly! Transactions are something that u need for a lot of applications, and they are also supported by MySQL in some table types ;) > So, apart from sub-querie

[ilugd]: Installing Linux on Pentium IV

2002-05-02 Thread Sanjay Gupta
Any Idea whether RHL 7.2 can be loaded on a P4 box Sanjay To subscribe, send email to [EMAIL PROTECTED] with subscribe in subject header To unsubscribe, send email to [EMAIL PROTECTED] with unsubscribe in subject header Archives are avai

RE: [ilugd]: Installing Linux on Pentium IV

2002-05-02 Thread D.Venkatasubramanian, Noida
Hi, >Any Idea whether RHL 7.2 can be loaded on a P4 box Yes, though some audio chipsets are not supported. I loaded it on a machine with built-in audio, it even autodetects the audio device but somehow did not work. Regards, Venky To

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Ambar Roy
> Exactly you cannot compare ferrari engine with fiat > palio's. You can only compare them if they perform the > same function. you need a ferrari for race tracks and > palios for delhi roads. Why would you put ferrari on > delhi road when you know there will be red light and > other traffic probl

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Ambar Roy
> > > supports is better memory management? > > Last time i checked, MySQL didn't hav any built in caching algorithm. That > > was 3.22.xx version series. For disk caching MySQL depends on the OS, and > Was in their todo list in last year, should be done by now. So was sub selects & stored procedu

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Raju Mathur
> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes: Ambar> First thing, ferrari engines are not always used in race Ambar> tracks. U do get ferrari road cars that u can drive on Ambar> delhi roads. It is a different matter that u wud be Ambar> extremely irritated when u drive a

Re: [ilugd]: Installing Linux on Pentium IV

2002-05-02 Thread Ambar Roy
> >Any Idea whether RHL 7.2 can be loaded on a P4 box > > Yes, though some audio chipsets are not supported. I loaded it on a machine > with built-in audio, it even autodetects the audio device but somehow did > not work. This is not wrt RHL 7.2, but distributions with older linux kernels might ha

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Ambar Roy
> Boss, how about writing in English for a change? I must confess that > I skip over all your posts because they're impossible to read even > though you appear to be talking useful stuff. I was under the impression that I was writing in some english dialect! Can you please tell me how I can impor

Re : Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Kapil Sethi
It Looks that most of the people are ignoring a very important that it is the amount of I/O with a DBMS is doing. If for the same type of repeated operations i.e. adding of UNIQUE records to a table with few lakh records is to be done then the faster DBMS is the one which will require lesser

RE: [ilugd]: MySQL evaluation

2002-05-02 Thread Leo Fernandez
At 01:32 PM 5/2/2002, you wrote: >I don't see where this discussion is headed. The basic difference between >Oracle and mySQL would be in the area of Query Optimization. Probably, this >And probably, that is why Oracle costs money. mySQL is a good database for >small applications. Before using

Re: [ilugd]: [Fwd: Modem Problem]

2002-05-02 Thread Abhishek Kumar
hi nikshant, your modem might be interal ISA modem linux architecture does not suport ISA modem get a PCI modem bye abhishek _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.

Re: [ilugd]: Installing Linux on Pentium IV

2002-05-02 Thread Ambar Roy
> Any Idea whether RHL 7.2 can be loaded on a P4 box RHL 7.2 does work on a P4 box! Bye, /\ |\/| |3 /\ r To subscribe, send email to [EMAIL PROTECTED] with subscribe in subject header To unsubscribe, send email to [EMAIL PROTECTED] w

Re: Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Ambar Roy
> It Looks that most of the people are ignoring a very important that it is the amount of I/O with a DBMS is doing. If for the same type of repeated operations i.e. adding of UNIQUE records to a table with few lakh records is to be done then the faster DBMS is the one which will require lesser I/O

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Vipul Mathur
> Again, I have no clue _why_ or even _if_ Oracle is "faster", just that the > simpler solution need not be the "better" solution. The following links should help: Server Databases Clash http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp MySQL vs Oracle http://www.geocrawler.com/mail/

[ilugd]: maximum file/directory limit

2002-05-02 Thread bsf
i would like to know is there a limitation of the number of files/directories i can have. i am using RedHat 7.1. Download Yahoo! Score Tracker for live cricket scores on your desktop

Re: [ilugd]: [Fwd: Modem Problem]

2002-05-02 Thread Ambar Roy
> your modem might be interal ISA modem linux architecture does not suport ISA > modem get a PCI modem Please don't give wrong info on this list. I have successfully used ISA modems under linux. They just appear as a regular serial port/modem under linux. It is a PCI modem that will cause the maxi

RE: [ilugd]: MySQL evaluation

2002-05-02 Thread Lokesh Bhog
> There may be some difficulty in defining how small > is "small" and how > large is "large". There would also be many other > considerations like kind > of information being stored in the database, > complexity of the relations > between tables etc..etc which goes into > decisions on wha

Re: [ilugd]: MySQL evaluation - >net slang

2002-05-02 Thread amit soni
In next Linux meet, a force graduation for Raju on Internet shortcut ***lingo***. > Ambar> procedures :) There are lots of other reasons.. (like for > Ambar> e.q. i might be getting Oracle for free, or your dba knows > Ambar> only oracle , etc) > > Boss, how about writing in English f

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread amit soni
Thanx Vipul ! A few things for people who didnt read the articles... - MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. - SQL Server and MyS

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread amit soni
> Can some one tell me the exact cost of oracle on > Linux? Should be close to $30,000. Approximatly the amount in which you could buy 5 servers and hire raju for 30 minutes to setup load balancing and fine tune all the servers. ;o) T

[ilugd]: Linux Awareness Program

2002-05-02 Thread Gami
hello everyone, some of my friends and I are planning to work towards creating awareness among people about the GNU/Linux Operating System and the Free Software/Open Source ideologies. Ideas and suggestions for the same are welcome. Also, anyone interested to join us and work for the same can cont

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Raju Mathur
> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes: >> Boss, how about writing in English for a change? I must >> confess that I skip over all your posts because they're >> impossible to read even though you appear to be talking useful >> stuff. Ambar> I was under the imp

Re: Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Raju Mathur
> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes: >> It Looks that most of the people are ignoring a very important >> that it is Ambar> the amount of I/O with a DBMS is doing. If for the same Ambar> type of repeated operations i.e. adding of UNIQUE records Ambar> to a ta

Re: [ilugd]: MySQL evaluation

2002-05-02 Thread Raju Mathur
> "amit" == amit soni <[EMAIL PROTECTED]> writes: >> Can some one tell me the exact cost of oracle on Linux? amit> Should be close to $30,000. amit> Approximatly the amount in which you could buy 5 servers and amit> hire raju for 30 minutes to setup load balancing and fine

Re: [ilugd]: maximum file/directory limit

2002-05-02 Thread Goldwyn Rodrigues
It depends on the number of inodes written on starting of the partition, which is usually very huge and equal to the number of blocks in the filesystem. Hnece, number of blocks free after a fresh format is the maximum files you can create. Someone correct me if i am wrong. Goldwyn :o) > > i wo

Re: [ilugd]: MySQL evaluation -> Oracle development + raju on hire.

2002-05-02 Thread amit soni
> >> Can some one tell me the exact cost of oracle on Linux? > amit> Should be close to $30,000. > amit> Approximatly the amount in which you could buy 5 servers and > amit> hire raju for 30 minutes to setup load balancing and fine > amit> tune all the servers. ;o) > I object -

Re: [ilugd]: Installing Linux on Pentium IV

2002-05-02 Thread Harshal Vaidya
Yes Sir, By all means. I am running RH 6.2 on Pentium IV and i am sure RH 7.2 would run too. --- Sanjay Gupta <[EMAIL PROTECTED]> wrote: > Any Idea whether RHL 7.2 can be loaded on a P4 box > > Sanjay > > > > To subscribe, send

Re: [ilugd]: MySQL evaluation -> Oracle development

2002-05-02 Thread Kapil Sethi
>Doesnt oracle9i come with a minimum 5 pooter license these >days ? >Perhaps they realised, nobody will buy oracle for a single PC. Oracle 8i & 9i is a free download for non commercial use and evaluation. and it is not time bound as well. So you can have your personal benchmarks and then comm

[ilugd]: DEFCON

2002-05-02 Thread Harshal Vaidya
Just thought that this would be interesting.A forward from another mailing list. --- D E F C O N 10 C O N V E N T I O N D E F C O N 10 C O N V E N T I O N DEF CON 10 CONVENTION

[ilugd]: does getting RHCE makes job prospects better?

2002-05-02 Thread rahul singh
hi all, i want to ask here is: whether RHCE makes getting a good job esaier? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. To subscribe, sen

Re : [ilugd]: does getting RHCE makes job prospects better?

2002-05-02 Thread Kapil Sethi
>hi all, >i want to ask here is: >whether RHCE makes getting a good job esaier? sorry for disheartning comments dear friend, but the law of jungle says that you get higher salaries to work on expensive equipment only. RH is free, Intel equipment is cheap so the salaries of a systemadmin wo

Re: [ilugd]: MySQL evaluation -> Oracle development

2002-05-02 Thread amit soni
> >Doesnt oracle9i come with a minimum 5 pooter license these >days ? > >Perhaps they realised, nobody will buy oracle for a single PC. > Oracle 8i & 9i is a free download for non commercial use and evaluation. and it is not time bound as well. So you can have > your personal benchmarks and then

RE: [ilugd]: does getting RHCE makes job prospects better?

2002-05-02 Thread Ashok Appu
Hi Rahul, My personal feeling is that RHCE won't be a bad thing to go for. However, if you already know more than what is covered in the Red Hat objectives and your communication skills are above average you can do without the certification. I don't know abt whether there are companies that are