Speed Is An Issue--Do I Need a More Robust System?

[mpoor]

I have a recently compacted & repaired 236kb Access2K file. I have four tables linked (coming from other compacted databases). I created a union query which contains the following sql statement:

SELECT [2 Record_id], [2 Email_addr], [2 Male], [2 State]
FROM 20020408EFXMainFileB
WHERE [2 Male] = "1"

UNION SELECT [2 Record_id], [2 Email_addr], [2 Male], [2 State]
FROM 20020408EFXMainFileB
WHERE [2 Male]="1";

The query takes more than 10 minutes to run. I need to revise the sql to include 7 or 8 more statements but I fear, if I do, that the thing will take forever to run. Am I doing something wrong? I have the choice of running this off of my pc or a dedicated server. Either one is comparably slow. I'm wondering if anyone can tell me whether my server or pc is robust enough for the task? See my pc/server specs below:

SERVER SPECS
O/S: WIN2K Member Server
Memory: 256 MB
CPU: 650 Mhz
Hard Drive: NTFS w/C:Master & D:Slave
c: 2 gig free
d: 6 gig free

Software: Access2K (only have this one application on the system)

PC SPECS
O/S: Win98SE
Memory: 384 MB
CPU: 650 Mhz
Hard Drive: Fat32
5 gig free
Software: Office2K and others

 

[Stickarm]

Do you have any indexes on these tables, if not indexing the fields in your "Where" clause may speed it up.

Phil

 

[jymm]

I think Stickarm has a good suggestion, but I have also found that breaking the query into pieces seems to speed things up ... the Union of the same data looks a bit odd to me --- and from what I remember, Access and Union the Union statement were not built for each other.

Jim