> select * from MYTABLE where id=200
>
> takes
>    Total execution time: 5.388s
>    PLAN (MYTABLE INDEX (PK_MYTABLE))
>
>   the same query executed local on the server(same db,server) takes  0.065s
>
> queries are done with Flamerobin,from IBExpert the same results
>
> How can I improve remote speed?

SELECT the columns that you actually need.

SELECT * is fine for debugging, but IMO a slackers approach for production code.


Sean

P.S. What is the latency/PING time of your connection to the remote server?