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 need to

[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

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 my bad

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 my bad