|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Firebird ODBC driver Traffic too high
Hi... I'm having some severe problems with the amount of traffic a simple query is producing via the ODBC driver.
I'm executing the following query several times (thousands) within a VBA program running on Excel: SELECT SUM(Promedio) FROM Captacion WHERE BUC='X' AND Corte='Y' GROUP BY BUC After 11,000 times the query has run, it has produced about 480MB of network traffic, and obviously has taken a pair of hours to run. The time right now is not the issue, but the amount of data travelling, 'cause I'm at a location having heavy traffic outbreaks, and as my app is not top priority my IP is getting blocked constantly. I'm using ADO via the ODBC to do it. Any help? |
|
#2
|
||||
|
||||
|
AFAIK Firebird's ODBC driver does not have any compression ability, you could try to use a compressed tunnel to add this feature.
I did the same for encription, using Stunnel. The new (4.0.x and above) version of stunnel has a compression option which coud help you ( Quote:
Look at my sig for tutorial about Firebird and Stunnel, but note that Stunnel needs to be installed on server and on each client connecting to it.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
The stunnel approach got too complicated for my technical knowledge... if anybody thinks of another way to do it... thanks.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Firebird ODBC driver Traffic too high |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|