M
mattc66 via AccessMonster.com
Hi Tom,
I have run it now with the live data around 5000 records. 8meg of data. When
I run the SQL ranking stuff it pegs the processor. After about 5 hours of
just letting it run, i killed the process. It showed that it was still runing.
I compressed the database and tried it again. I get the same result.
I then took the query and had it only select the names starting with the
letter "A*" that worked. So I then opened it up and did a rang. It looks like
it works okay with 200 records, but if it gets around 500 records it takes
about 20-30min to run the ranking.
I have tried it on 2 different machines with the same results. Machine 1: P4
3.0mhz 512k Ram with 80gigs free hard drive. Machine 2: Centrino Laptop 1.?
Mhz 1gig Ram with 60gigs free.
Do you have any thoughts on how I could improve this process?
Thanks
Matt
I have run it now with the live data around 5000 records. 8meg of data. When
I run the SQL ranking stuff it pegs the processor. After about 5 hours of
just letting it run, i killed the process. It showed that it was still runing.
I compressed the database and tried it again. I get the same result.
I then took the query and had it only select the names starting with the
letter "A*" that worked. So I then opened it up and did a rang. It looks like
it works okay with 200 records, but if it gets around 500 records it takes
about 20-30min to run the ranking.
I have tried it on 2 different machines with the same results. Machine 1: P4
3.0mhz 512k Ram with 80gigs free hard drive. Machine 2: Centrino Laptop 1.?
Mhz 1gig Ram with 60gigs free.
Do you have any thoughts on how I could improve this process?
Thanks
Matt
Tom said:Dear Matt:
For double the fee (currently $0.00) I will answer in English next time.
Greek is rough on me, too!
Tom Ellison
[quoted text clipped - 35 lines]Hi Tom,