Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 To: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 Tags
Subject: RE: Table with large memos
Thread ID: 268876 Message ID: 268911 # Views: 35 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, July 15, 2010 11:04:13 AM         
   


Thank you Tom, Tushar & Jun
I think you answered my question. Performance is not affected unless I require the memo fields, and moving memos to other files is done for other reasons than performance.

> Hi experts,
> I have not much experience with data transfer over LAN.
> Will there be a performance gain if I separate memo fields from the main dbf file into another dbf?
> These memos will probably have large amounts of data.
>
>

> #Students.dbf structure#
> ID
> name
> birthdate
> gender
> email
> class_id
> ...
> ...
> ...
> *below, 3 memo fields* -> move these memo fields to a separate file?
> address
> teacher_notes
> general_attitude
> #end of Students.dbf structure#

>
>
> Regards
> Samir



Regards
Samir

ENTIRE THREAD

Table with large memos Posted by Samir H. @ 7/15/2010 7:32:34 AM
RE: Table with large memos Posted by Tom Saddul @ 7/15/2010 8:55:33 AM
RE: Table with large memos Posted by Samir H. @ 7/15/2010 9:23:20 AM
RE: Table with large memos Posted by Jun Tangunan @ 7/15/2010 10:02:18 AM
RE: Table with large memos Posted by tushar @ 7/15/2010 10:15:10 AM
RE: Table with large memos Posted by Samir H. @ 7/15/2010 11:04:13 AM
RE: Table with large memos Posted by Samir H. @ 7/16/2010 4:58:46 PM
RE: Table with large memos Posted by Stefan Wuebbe @ 7/16/2010 6:45:05 PM
RE: Table with large memos Posted by Samir H. @ 7/17/2010 5:52:52 AM