Comments by Member 11727760

Member 11727760 16-Feb-16 14:28pm View

Sorry, maybe i was misunderstood. After the query it was obviouvsly returned me just a record, the 'where' clause with the field named 'key' select only one row.
Instead a query that asked a single record, i have noticed that SQL server load the entire table in memory.
When the table, that is growing in time, become bigger to raise the maximum size of memory reserverd into SQL server the query become slowly;
Should the "SELECT TOP 1..." than "SELECT *..."'s solution make it better?

Member 11727760 16-Feb-16 12:23pm View

The 'Key' named field is unique; it is a string field with a date formatted into.
With this assumption do you think changing the query from the original "Select *..." in your's "Select TOP 1 *.." should make it quickly?

I have observed that the entire Table is loaded into memory, for future query.. but in this case, when the memory raises the maximum value (cause the record table raises...) then disk access happening.

Member 11727760 15-Feb-16 8:34am View

"SELECT * FROM [Temperatures] WHERE IdMachine = " & Id & " AND Key= '" & Key& "'"

Member 11727760 12-Feb-16 16:07pm View

I think is not a query problem, i use the where clause with a single field named 'key' that is a string formatted with the date info and minutes details.
This field is also indexed.

I hope there is an unknown configuration option of SQL server, because this delay happened when the used memory raise the maximum size limit.

Member 11727760 12-Oct-15 11:39am View

Excuse me Sergey if i wasn't clear enough.
The question is how to declare on runtime using emit the follower class
Class StructRegMT {
On as boolean;
NrItem as integer;
SetPointRegMT(64) as integer;
} end Class

then i have to instantiate an oject of this type, can you help also in this?

Member 11727760 12-Oct-15 2:53am View

Dear Sergey, i replied your previous comment. See above, and help me please about the syntax to use with a dynamic "array" field.
i tried this:

dim fv as FieldBuilder = tb.DefinField("ia", GetType(integer).Makearraytype(), fieldAttribute.Public)

but how to fix the size of the array "ia"? Should i pass the size via Argument while calling the constructor? in this case how to call it?

Member 11727760 10-Oct-15 16:11pm View

Queing the PLC, it answer with a list of tag. Each tag coul be a variable type like: atomic (boolean, integer, ecc), array or structure. In the latter case the PLC return also the "template" of the tag; it is like a list of member with the associated atomic type each.

Once i have recovered this 'list' i would like to translate into a VB.net class each returned structure. Cause in following operation i would like to 'read/write' some tag, and i should translate the frame of byte i'll receive. I should search in the frame the exact byte that represent the value...

This operation is mandatory because the PLC (the server) could change his structures and i have to ask him the list of templates.

Returning on topic, thanks for your reply, but i have some difficult to realize the above class with "typeBuilder" and the array. What's the syntax i should use to realize the SetPointRegMT(64) as integer field in a dynamic class?

Member 11727760 14-Sep-15 3:08am View

ok.
Anyone can help me making it selective?

Member 11727760 3-Jun-15 6:36am View

Hi Ralf, thank you so much about your solution.
What about using Reflection and Assembly to find the upperlevel class index from the Button?
I have not any expierence about Assembly, can you help me?

Member 11727760 29-May-15 12:13pm View

See the edit post
Matteo

Member 11727760 29-May-15 8:52am View

Thank you Ralf, but in this solution you give me back the parent form control, a graphic object like a "groupbox".
My question is to get the control of base class "RegVel(I)", without any tag.
Can you help me?

Member 11727760 29-May-15 6:52am View

Hello Ralf,
i would like to know the parent from the 'source'.

ButtTrain is a member of RegVel(I), initialized like RegVel(I).Buttrain; i would like to know into 'source' which RegVel (without passing any tag) or, better, get the control of RegVel. Is there a method to call?

thanks for help
Matteo M.

Comments by Member 11727760 (Top 12 by date)