AW: [dbforms] Problem using queryData for huge tables

2004-04-06 Thread Henner Kollmann
> > I've got a huge table (about 60,000 entries), let's call it > HUGETABLE. It consists of two columns, HT_ID and NAME. I'm > referencing to it via a foreign key in another table. > > I tried to use this command: > > > > But this takes a very long time, sometimes even producing a > jav

[dbforms] Problem using queryData for huge tables

2004-04-06 Thread "Daniel Süpke"
Hi, I'm wondering how I could solve this problem without using a workaround: I've got a huge table (about 60,000 entries), let's call it HUGETABLE. It consists of two columns, HT_ID and NAME. I'm referencing to it via a foreign key in another table. I tried to use this command: But this t