Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Table or Queries
Tue, Dec 12 2006 5:18 PMPermanent Link

Stephane Lariviere
Hi

I'm new user with DBISAM and i want to know what is the best use queries or Table?

I mean what is the best for performance and reliabilite.

I'm old programmer with a lot of experience with paradox table and i switch to DBISAM.
After eleven year with delphi and paradox table it's time change.

A+
Wed, Dec 13 2006 1:22 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Stephane,

<< I'm new user with DBISAM and i want to know what is the best use queries
or Table? >>

It depends upon your needs.  Live query results are essentially the same as
a table with a filter applied, and canned query results are generated in a
temporary table:

http://www.elevatesoft.com/dbisam4d5_live_queries_and_canned_querie.htm

<< I mean what is the best for performance and reliabilite. >>

There really is no difference between the two in terms of those two things.

Frankly, if your application currently uses tables, then I would stick with
tables if you simply want to convert over to DBISAM with a minimal amount of
work.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Dec 14 2006 10:48 AMPermanent Link

"Ivan Sine"
What took you so long!?! <bg>
Seriously, you're going to love working in DBISAM after Paradox.
Thu, Dec 14 2006 10:50 AMPermanent Link

As mentioned, it depends on your requirements, but there is much more room
for
growth if you use SQL.

Regards,
Scott.

"Stephane Lariviere" <stephane@bblinfo.com> wrote in message
news:9E6D2803-C1F2-4851-B54D-6C5493A985FE@news.elevatesoft.com...
> Hi
>
> I'm new user with DBISAM and i want to know what is the best use queries
> or Table?
>
> I mean what is the best for performance and reliabilite.
>
> I'm old programmer with a lot of experience with paradox table and i
> switch to DBISAM.
> After eleven year with delphi and paradox table it's time change.
>
> A+
>

Tue, Mar 6 2007 4:27 AMPermanent Link

adam
I did the same change as you about 5 years ago.

I went with tables at the time (but with DBISAM V2 ... less solid than V4) ... but switched quite fast to SQL Queries.

* Faster in many (not all) contexts, sometimes massively so.
* I settled for a "non live" way of working with data ... most SQL views are "canned" so you can't edit directly ... so this was actually easier for me.
* You can much more easily generate views that join different data tables. This was good for me as my databases have become more relational.
* Extremely fast for returning small results sets with multiple joins ... impossible with tables.


ISSUES:

... learning SQL: though DBISAM SQL is pretty easy & there are decent GUI tools to auto-generate SQL until you get the hang of it (good freeware tool at Fast-report.com).
... restructuring my DBs to make them more relational, to really take full advantage of SQL.
... implementing a mechanism for updating data when it isn't live (You have to write UPDATE SQL ... or use one of many tools for this job)

It is worth giving some time to get right, if you are planning to do a lot of it.

If on the other hand you are "just" porting an old APP & want the least possible work, then tables should be OK.

Adam


Stephane Lariviere <stephane@bblinfo.com> wrote:

Hi

I'm new user with DBISAM and i want to know what is the best use queries or Table?

I mean what is the best for performance and reliabilite.

I'm old programmer with a lot of experience with paradox table and i switch to DBISAM.
After eleven year with delphi and paradox table it's time change.

A+
Image