SQL statement slow - Xtreme Visual Basic Talk

11-16-2003, 11:44 PM

thiamhong

Newcomer

Join Date: Aug 2002

Location: Malaysia

Posts: 18

SQL statement slow

i have two table, 1st contain 40,000++ record, 2nd contain 13,000 record, i wrote a statement

SELECT id FROM table1 WHERE id NOT IN (SELECT id FROM table2)

When i run this statement, it takes about 25 minute to show the result, anyone got any idea to use other way to retrieve the data.......

thank you

__________________
Sincere,
thiamhong :)

11-16-2003, 11:54 PM

00100b

Martian In Disguise

Retired Moderator
* Guru *

Join Date: May 2003

Location: Minneapolis, MN

Posts: 9,566

What database engine are you using?
What data type is used for the [id] fields of both tables?
Is there an Index on the [id] fields in both tables?

__________________
The only stupid question is the one that goes un-asked.

11-17-2003, 03:01 AM

thiamhong

Newcomer

Join Date: Aug 2002

Location: Malaysia

Posts: 18

microsoft access 97, the data type of the field is "Text"

__________________
Sincere,
thiamhong :)

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL error in Vb Code	blong824	Database and Reporting	16	03-14-2004 05:07 PM
SQL Statement Troubles	verno_25_02	Database and Reporting	2	02-07-2003 05:49 PM
Problem with writing Twice	Renidrag	Web Programming	20	11-07-2002 02:52 PM
SQL Statement using like	dejota6	Database and Reporting	17	11-05-2002 08:44 AM
Creating Access Databases	TomGuy	Database and Reporting	8	07-10-2002 10:56 AM