SQL query verry slow on network drive

[Jan]

Hello,

I have a problem with paradox tables on a network drive and I cannot
change to another database system.
When I run a normal SQL query ( a table with about 300 records) like
"Select * from testtable" on a
local drive, it's run verry fast. When I execute this query on a 100
mbit network connection it takes more than 3 seconds for this query.

I use BCB 5 pro.

Any idea ?

Thanks,
Jan

[Jayme Jeffman]

Hello,

No matter your network has a very good speed, it is always more slowly
than the computer memory bus. So it is a good advice do not use a SQL
select command like "SELECT * FROM table" without a "WHERE" clause
to limit the number of records fetched. It is uncommon the need of all
records from a table.

The more records you fetch, the more traffic you will have on the network!

Components from others vendors, like the ones you may check at
www.crlab.com,
have a property which allow to limit the number of fetched rows, to prevent
this waiting time to show some data on the screen.

HTH

Jayme.

Post by Jan
Hello,
I have a problem with paradox tables on a network drive and I cannot
change to another database system.
When I run a normal SQL query ( a table with about 300 records) like
"Select * from testtable" on a
local drive, it's run verry fast. When I execute this query on a 100
mbit network connection it takes more than 3 seconds for this query.
I use BCB 5 pro.
Any idea ?
Thanks,
Jan