1. Helge Tjelta
  2. Valentina Server
  3. Monday, March 28 2016, 05:09 PM
  4.  Subscribe via email
Hi, any big advantages with server side cursor when running as web-app (stand alone, mac), VS direct Xojo API. ( i.e. collect fields then mTable.updateRecord())

I'm starting to have some hangs (4-5 secs) when doing stuff, having all cursors on server side in my session module. any ideas...
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Helge,

can you please describe the current state of app?
I mean something as:
* now xojo web app uses server-side cursors
* it use cursors to update record. One?
* N fields
* fields are ...
* exists up to N clients..
* hang happens when?
* OS X? Linux?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 1
Helge Tjelta Accepted Answer
Hi Ruslan, I'm in the development phase now, so N of clients is only 1.
I have a lot of fields, 3-4 cursors. All on OSX

Fields are boolean, tekst, numbers and dates + object pointers. etc.

I log into my web app (running on mac), go to my first container page and start to show a lot of info. All this is while having the cursors as a property of the session, and not the window. As I will have iphones/androids as well running this web-app.

I'll try to do some more detailed info ones I understand when it happens...
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 2
Helge Tjelta Accepted Answer
Hi Ruslan, looks like my hangs is related to Xojo 2016b23.... went back to b22 and all is good...

But still my original question: serverside VS direct API...
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 3
Ruslan Zasukhin Accepted Answer
Hi Helge

ok for b22

In any multi-user env -- I think we should prefer SQL and cursors because they have record locks.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 4
Helge Tjelta Accepted Answer
b22 works good. and thanks for the reply on my subject... I'll stick with serverside cursors then...

Now I only have to figure out why my app crashes on quiting my webbrowser...
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 5
Helge Tjelta Accepted Answer
well, looks like b22 is halting a little bit as well... :D

But; serverCursors, will they work one level deeper ? with an updateRecord() of the cursor.


i.e see below... will my fields in the linked table work.

will a f1->f1Linked work when update server cursor? I don't get it to work...


sql = "SELECT RecID, Selger->Fornavn AS sFornavn, "+_
"Sted, Dato, FinnKode, Kjoper, Kontrakt_type, LevDato, MerknaderStandardutstyr, "+_
"FROM Inn "+_
"WHERE recID = '"+ session.kInn+"'"

if Session.mConnection.IsConnected = TRUE then
session.curs_k_inn = Session.mDatabase.sqlSelect(sql, EVCursorLocation.kServerSide, EVLockType.kNoLocks)
end if


doing a setString for a field in the object pointer table, will not update...

i.e.:
session.curs_k_inn.Field("sAdr";).SetString("New adress";)

where sAdr is a field using object pointer and to address field inside this linked table.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories