Data type?
Hello guys i am new at ninox but i understand database data structures and normalization rules, however i would like your help to understand ninox since my business runs a lot of records and proceses, i do have the following questions?
How can i do the normalization in my database?
What type of data estructure is used in the different fields?
How does ninox prevent data corruption for excesive flexibility in data and fields modifications?
Since there is not an option to select between file types such char, varchar, int, boolean, what guarantee do i have that my database will not become slow when i reach something about 20000 records?
Best regards
Jake Harris
4 replies
-
Hi Jake
No guarantee that your database won't slow down but that won't be caused by your choice of field type. There are forum members here with record sets of over 500,000 who are perfectly stisfied with performance. If you have set up your relationships well they can be used in a powerful way without having to resort to select statements.
Regards John
-
Thank you very much for your fast reply, I was trying to create the normalization levels normalization in my database but i am stuck in the process because i would like to get a dropdown where i can access to the information from other external tables, and i wonder if ninox allow multiple table levels so i could create a child table which could include another child. Just to explain you what i need, i will put an example. Let say you have a car table, the parent table will be the type: (suv, sedan coupe), the next child table will have the brands (lexus, honda, etc), the grand child table will have the models (pilot, odyssey, cr-v) and let say one last table grand child which includes the years. Now been said i would like to know if if could get a dropdown which will let me choose the items from every child table related.
Best regards
Jake Harris
-
Hi Jake -
Ninox can handle child and grandchild tables very well.
-
Jake
I have 622,794 plus records in one table and all working fine. (cloud version!). However, understand one has to accept that trying to pull all this data over the net and in one go is therefore going to have some impact as depending on broadband speed there will bit of a delay.
I'm on ordinary fibre broadband - 72mb download. - So just by using the standard table display, if I pull down every record then there is about 40 second delay to get records in entry order and display sort them in customer account order. However once displayed everything other action is instant.
If I was to further get this info by creating a dummy table (or dashboad) and applying a table view (with additional search fields for limiting the return of data) then return of all data only takes about 15 seconds. Limited daya is only a few seconds - As the script in the view uses ‘do as server’ so all sorting is done Ninox side before display at my end.
However the point here is that I never ever need all 622k records displayed in one go - I only want to sweep it certain records info.
Hence the extra search fields to do the filtering
Exaple of one of my view scripts on this table
do as server
let xBeg := 'Begin Date';
let xEnd := 'End Date';
let xItem := Item;
if Choice >= " " then
select Leads where 'Order Date' >= xBeg and 'Order Date' <= xEnd and 'Job Type' = xItem
else
select Leads where 'Order Date' >= xBeg and 'Order Date' <= xEnd
end
end
eg another of my tables has 9600 records (in each record there are a bout 42 fields of info and about 3/4 image fields)
On loading it takes less than 2 seconds to get all the info from ninox server in record entry order and redisplay them in customer account order
this is a direct load with NO - do as server etc.
Mel
Content aside
- 3 yrs agoLast active
- 4Replies
- 322Views