BorlandTalk.com

Jan · Guest

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 · Guest

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.

"Jan" <jan (AT) jlcsoft (DOT) com> escreveu na mensagem
news:452cafb0 (AT) newsgroups (DOT) borland.com...