TIP: Click on subject to list as thread! ANSI
echo: paradox
to: ALL
from: KENNETH ULLMAN
date: 1995-08-08 16:49:00
subject: queries

I'm having a problem with one of my queries. Actually not a problem but kind 
of a performance problem.  I query the db on a field that is not zero. the 
field is a money field.  regardless of whether or not I indexed the field, 
the response time hovers around twenty seconds. There're only 9000 recs in 
the db. Its seems unusually long.  My config is 486-33 with 8mb ram. What am 
I doing wrong?
thank you!
--- FLAME v1.1
---------------
* Origin: HAL-PC - (713)963-4100 (1:106/4100)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.