offtopic: db-processing speedup in C

Hi all,

If I want to speedup a simple query (simple enough to implement
effectively (and easily ;) in C), one way is to fetch the whole table
into memory, and work from there directly. Now, if the table is
fairly big, then I need to use index(es). Is there a C lib with
appropriate funcs to use if I want to reach better speed than the
sql-server?

I just want to use simple queries like this:

SELECT a.* b.value1 b.value2 FROM a,b WHERE a.b=b.key;

>From what number of records in 'b' is suggested to use an index on
b.key?

Thx:
Circum
__  @
/  \    _   _                                           Engard Ferenc
l    | ( \ /  | | (\/)                      mailto:s-fery@kkt.sote.hu
\__/ | |   \_ \_/ I  I                    http://pons.sote.hu/~s-fery