firebird and win XP

can someone tell me how to speed my firebird under windows xp ?
i'm making a program using mysql ...it was fast. now, i've put it with firebird, and it'a really slow ( with the same fields , table ...)

thx

How much RAM do you have?

1024

1Gb? That's fine, start editing your firebird.conf (located in c:\program files\firebird\firebird_1_5) and double every memory related value .... sort of, increment:

- number of pages from any one database that can be held in cache at once:
DefaultDbCachePages

- The amount of memory allocated for each sort block:
SortMemBlockSize

- The maximum amount of memory to be allocated by the in-memory sorting module, the value applies to each client
connection/server instance and thus consumes a lot of memory
SortMemUpperLimit

(be careful and check the number of connections).

You can also install a RAMDisk (there are some free ones also) and put the temporary files on it.
You can achieve this by changing the TMP and TEMP environment variables (this way you'll move ALL temporary files there, the best option) or by setting the FIREBIRD_TMP env var or the TempDirectories parameter (Firebird temp files only).

Once I did some benchmarking on Firebird and it was slower than MySQL but in that case I didn't apply any optimization, do you plan to collect such data?

I would also recommend:
Use the "index", Luke !