Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Form Load speed
Message
From
09/04/2002 04:25:35
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
09/04/2002 02:12:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00642483
Message ID:
00642512
Views:
12
>Hi Guys,
>
>I have a form containing a pageframe than consist of 67 pages. Each pages has specific collection of controls like grids, textboxes, editboxes, combobox etc. I also have 67 tables that corresponds to each page. My question is if I have to use the tables in the load event of my form, without re query, will it affect the speed of the form?
>
>Your advice and suggestions will be greatly appreciated....
>Thanks in Advance....

Mike,
Opening of 67 tables has much less impact on speed than creation of objects on 67 pages. (Try with a backup of original as always)
-Create a class for each of your pages (Select controls there and saveas class)
-Also include opening/requerying of table in class
-After creating each class delete objects on page and in Page.activate code :
if type('this.ClassNameForPage')#'O'
 this.NewObject('ClassNameForPage','ClassNameForPage','ClassLibName.vcx')
 this.ClassNameForPage.Visible = .t.
endif
You might need some enhancing in code.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform