I didn't know it was compressed?
Cool, My boss willlove that!!

I am Building indexes now so I can run query tests.

I just hope it can compare to Codebase 6.5 for retrieving records?

In codebase 6.5 (xbase, Fox pro table and Index cdx), I could run
a xbase query like this

LATITUDE >= "038384736" .AND. LATITUDE <= "038384882" .AND. LONGITUDE

>= "096328473" .AND. LONGITUDE <= "096328662"

Codebase would usaully take between 3 to 6 seconds to return results.


Question:

Should I query in IB like this:

SELECT * FROM EXPERIAN WHERE LATITUDE BETWEEN "xxxxxxxxx" AND "xxxxxxxxx"
AND
LONGITUDE BETWEEN "xxxxxxxxx" AND "xxxxxxxxx"

or

SELECT * FROM EXPERIAN WHERE LATITUDE >= "xxxxxxxxx" AND LONGITUDE >= "xxxxxxxxx"
AND LATITUDE <= "xxxxxxxxx" AND LONGITUDE <= "xxxxxxxxx"


thanks, mike

-----Original Message-----
From: Doug Chamberlin [mailto:dchamberlin@...]
Sent: Friday, August 17, 2001 8:00 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Importing From External File


At 8/17/2001 09:04 AM (Friday), Mike Grover wrote:

>Well I split my 2 large SDF Data files into files 5 million records each.
>Total size of all files was 38 gig.
>I then setup tables to external files.
>Next I Imported from each table like this..
>It finished with out errors...
>Problem is that the total of all gdb files is 26 gig?
>I wonder what data is missing?

Probably none. GDB files contain database records which are automatically
compressed using a simple but usually effective run-length encoding scheme.

Sounds like you did it!


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Do you need to encrypt all your online transactions? Secure corporate intranets? Authenticate your Web sites? Whatever
security your site needs, you'll find the perfect solution here!
http://us.click.yahoo.com/Bre3tC/Q56CAA/yigFAA/dpFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/