Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 10th, 2005, 08:28 PM
HereSomeHow HereSomeHow is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Location: Guadalajara, Jalisco, México
Posts: 62 HereSomeHow User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 h 51 m 29 sec
Reputation Power: 4
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?

Reply With Quote
  #2  
Old February 11th, 2005, 05:21 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,925 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 20 h 9 m 23 sec
Reputation Power: 279
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:
compression = zlib | rle
select data compression algorithm

default: no compression
).
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.

Reply With Quote
  #3  
Old February 14th, 2005, 08:54 PM
HereSomeHow HereSomeHow is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Location: Guadalajara, Jalisco, México
Posts: 62 HereSomeHow User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 h 51 m 29 sec
Reputation Power: 4
The stunnel approach got too complicated for my technical knowledge... if anybody thinks of another way to do it... thanks.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Firebird ODBC driver Traffic too high


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT