Celeron 333, ram 256, win NT. semua data base di akses dari network client cara execute : untuk fb dengan looping di delphi (letak delphi di client, bukan di lokal server) kemudian select count(*) pada delphi juga
untuk sql server looping di query analyzer yang ada di client (bukan di local server) kemudian select count(*) pada QA ----- Original Message ----- From: "Squid" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 3:36 PM Subject: Re: Re[2]: [Delphindo] (OOT) fungsi aggregate firebrid lambat > 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/ > > > 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/
