Heran ... kok bisa jauh sekali bedanya ... kalo bisa ... tolong disebutkan jenis komputer yang dipake, tempat instalasi FB dan MS-SQL-nya, cara eksekusi perintah SQL itu ... jadi bisa dianalisa "keloyoan" FB itu kena apa ...
Kalo ternyata FB di-install di network yang crowded lalu MS-SQL-nya lokal ya ... rugi sudah putar otak ... ^^; Salam, Sintar. ===================== ----- Original Message ----- From: "Ujok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 28 January 2003 2:47 PM Subject: Re: Re[2]: [Delphindo] (OOT) fungsi aggregate firebrid lambat > ----- Original Message ----- > From: "arif rahman" <[EMAIL PROTECTED]> > To: "Bayu" <[EMAIL PROTECTED]> > Sent: Monday, January 27, 2003 6:20 PM > Subject: Re[2]: [Delphindo] (OOT) fungsi aggregate firebrid lambat > > > struktur tabelnya sbb: > > tabel test > > nomor integer -> primary key > > nama char(500) > > alamat char(500) > > > > jumlah data 110000 > > > > perintah yang digunakan adalah: > > select count(nomor) from test where nomor>1 and nomor<100000; > > > > hasil statistiknya (IB Console) sbb: > > Execution Time -> 1.13 menit > > Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
