Re: [GENERAL] Select too many ids..

2007-10-03 Thread Alban Hertroys
Rodrigo De León wrote: > On 10/1/07, Abandoned <[EMAIL PROTECTED]> wrote: >> Hi.. >> I have a id list and id list have 2 million dinamic elements.. >> I want to select what id have point.. >> I try: >> >> SELECT id, point FROM table WHERE id in (IDLIST) >> >> This is working but too slowly and i ne

Re: [GENERAL] Select too many ids..

2007-10-02 Thread Rodrigo De León
On 10/1/07, Abandoned <[EMAIL PROTECTED]> wrote: > Hi.. > I have a id list and id list have 2 million dinamic elements.. > I want to select what id have point.. > I try: > > SELECT id, point FROM table WHERE id in (IDLIST) > > This is working but too slowly and i need to performance.. > > I'm sorry

Re: [GENERAL] Select too many ids..

2007-10-02 Thread Scott Marlowe
On 10/1/07, Abandoned <[EMAIL PROTECTED]> wrote: > Hi.. > I have a id list and id list have 2 million dinamic elements.. > I want to select what id have point.. > I try: > > SELECT id, point FROM table WHERE id in (IDLIST) > > This is working but too slowly and i need to performance.. > > I'm sorry

[GENERAL] Select too many ids..

2007-10-02 Thread Abandoned
Hi.. I have a id list and id list have 2 million dinamic elements.. I want to select what id have point.. I try: SELECT id, point FROM table WHERE id in (IDLIST) This is working but too slowly and i need to performance.. I'm sorry my bad english. King regards.. ---(end