Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Can I decrease packet size with using of persistent fields?
Thu, Mar 4 2010 2:48 AMPermanent Link

Laszlo Szabo

Dear Suppport!

I want to ask that:
Can I decrease packet size with using of persistent fields?

I have a big table (with many fields, more of them are varchar(x > 100)), and I want to read only some specific fields from that.

But I don't know which solution is better.

a.) No fields (dynamic), all is visible, all I get.
b.) Persistent fields. May the DBISAM/EDB is enough intelligent to read only these fields, and not all of them (like in A version).
c.) Live SQL with some range limitation. This solution provide only needed fields - but running of SQL have additional time (select) what I "must pay".

So main question that packet size of A and B are different or not?

Thanks for your help!

LSZ
  
Thu, Mar 4 2010 7:25 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Laszlo,

<< Can I decrease packet size with using of persistent fields? >>

Unfortunately, no.

<< So main question that packet size of A and B are different or not? >>

They are the same.  The only way to get a sub-set of the columns in a table
is to execute a SELECT statement that returns an insensitive result set.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image