coba gunakan index.
alinuxye wrote:
>
> sory di luar topik, tapi masih ada hubungannya kok dengan MySQL
>
> saya punya table 1 isinya sekita 100rebu record, dan table2 cuman 300
> record,
> kemudian saya mau joint
> misalkan
>
> table1 : kolom1,kolom2,kolom3,
> table2:kolom1,kolom2,kolom3,kolom4
>
> select a.* from table1 a,table2 b
> where a.kolom1=b.kolom1
>
> waduh..... bisa minta ampun deh nungggu hasil querynya...
> bisa-bisa gak jalan tuh querynya...
>
> dear master in MYSQL... any suggestion please....
> yang salah quernya apa MYSQLnya yang lemot ya??
> padahal saya dah pake server XEON 3GHz dan 2GB RAM
> karena saya coba di MSSQL ok-ok saja...
>
> thanks for advance
>
> Rgds,
> ceppek
>
> On 5/28/07, Bace - Bace <[EMAIL PROTECTED] <mailto:bace01%40yahoo.com>>
> wrote:
> >
> > ini link doanloadnya mysql cc
> >
> >
> >
> http://gudangupload.com/filelink.php?filecode=ced89c1c49789e749525d6270f377b716859dbbdbc056f9254254bebc8840141
>
> <http://gudangupload.com/filelink.php?filecode=ced89c1c49789e749525d6270f377b716859dbbdbc056f9254254bebc8840141>
> >
> > Semoga membantu: =(oVo)=
> > ====================
> > BaceInside Publisher
> > Copyright @2007
> > Not for reproduced, republished.
> > Thank You
> > ====================
> >
> > ----- Original Message ----
> > From: Lilis Suryani ArjaMaya <[EMAIL PROTECTED]
> <mailto:lilis_5ury4n1%40yahoo.com><lilis_5ury4n1%40yahoo.com>
> > >
> > To: [email protected]
> <mailto:indoprog-vb%40yahoogroups.com> <indoprog-vb%40yahoogroups.com>
> > Sent: Monday, May 28, 2007 8:34:29 AM
> > Subject: Re: [indoprog-vb] mysql cc
> >
> > kalo aku sih biasa pake sqlYog, powerfull banget tuh software,
> > jadi ga terasa kalo lagi pake mysql, karena tampilannya kaya
> > microsoft sql server
> >
> > salam
> > Lilis Suryani ArjaMaya
> >
> > ____________ _________ _________ _________ _________ _________ _
> > Don't get soaked. Take a quick peak at the forecast
> > with the Yahoo! Search weather shortcut.
> > http://tools. search.yahoo. com/shortcuts/ #loc_weather
> >
> > __________________________________________________________Yahoo!
> > oneSearch: Finally, mobile search
> > that gives answers, not web links.
> > http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
> <http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC>
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
