NetTalk Central
Toggle navigation
Login
Register
×
Welcome,Guest
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
NetTalk Central
»
NetTalk Web Server
»
Web Server - Ask For Help
»
TPS Table with 357,899 records - times out
« previous
next »
Print
Pages: [
1
]
Author
Topic: TPS Table with 357,899 records - times out (Read 5961 times)
rupertvz
Sr. Member
Posts: 323
TPS Table with 357,899 records - times out
«
on:
April 07, 2019, 10:58:21 PM »
Hi Guys,
I have a TPS table with 357,899 records which I am trying to link / view in a NWB.
I have a simple filter to display some of the records.
I am getting:
This page isn?t working - didn?t send any data.
ERR_EMPTY_RESPONSE
With less records the table contents display correctly.
Am I perhaps doing something wrong? Or is this amount of records too many for a TPS table to display?
Logged
rupertvz
Sr. Member
Posts: 323
Re: TPS Table with 357,899 records - times out
«
Reply #1 on:
April 07, 2019, 11:49:12 PM »
When I remove the NWB filter, the NWB loads fine (showing all records)
When I replace the NWB filter, the more records matches the filter, the quicker the browse loads
With little or no records matching the filter, the browser times out.
Logged
Robert Iliuta
Sr. Member
Posts: 472
Re: TPS Table with 357,899 records - times out
«
Reply #2 on:
April 08, 2019, 12:12:02 AM »
Hallo!
Can you post the filter?
Where you put filter code? in template or embed code?
Robert
Logged
rupertvz
Sr. Member
Posts: 323
Re: TPS Table with 357,899 records - times out
«
Reply #3 on:
April 08, 2019, 12:26:21 AM »
Thank you Robert,
The filter works fine with less records
The problem seems related to the large data set.
I tried two different options in the template;
Option 1:
Kindly see screenshot attached, my filter value "Pfe" is stored in LOC:Pfe
Option 2:
'C007:Pfe = <39>'&p_Web.GetSessionValue('GLW:Pfe')&'<39>'
* Where GLW:Pfe is my "Pfe" session value
Logged
Robert Iliuta
Sr. Member
Posts: 472
Re: TPS Table with 357,899 records - times out
«
Reply #4 on:
April 08, 2019, 01:23:10 AM »
I do not use filter in template (very rare)
Try to use in embed code: Before Browse Loop > Set Filter
loc:FilterWas = UPPER(C007:Pfe)&' = <39>'&UPPER(p_web.GSV('GLW:Pfe'))&'<39>'
ThisView{prop:Filter} = loc:FilterWas
Check and see id you see any difference.
I have TPS with more then 800.000 records and show just fine.
Robert
Logged
Bruce
Global Moderator
Hero Member
Posts: 11244
Re: TPS Table with 357,899 records - times out
«
Reply #5 on:
April 08, 2019, 02:13:48 AM »
Hi Rupert,
a) Do you have a KEY on the C007:PFE field ?
b) Is the key set as Case Sensitive?
c) Is the field a string or a long?
cheers
Bruce
Logged
rupertvz
Sr. Member
Posts: 323
Re: TPS Table with 357,899 records - times out
«
Reply #6 on:
April 08, 2019, 06:56:20 AM »
Hi Bruce,
a) Do you have a KEY on the C007:PFE field ?
I have a single key, with only one component on C007:Pfe (Not unique)
I also have other keys with C007:Pfe as a component
b) Is the key set as Case Sensitive?
No, this key is not case sensitive
c) Is the field a string or a long?
String(10)
Logged
Bruce
Global Moderator
Hero Member
Posts: 11244
Re: TPS Table with 357,899 records - times out
«
Reply #7 on:
April 10, 2019, 10:00:00 PM »
Hi Rupert,
The key exists, but is case insensitive. So the filter must be case insensitive as well. ie not
'C007:Pfe = <39>'&p_Web.GetSessionValue('GLW:Pfe')&'<39>'
but more like
'UPPER(C007:Pfe) = <39>' & UPPER(p_Web.GetSessionValue('GLW:Pfe')) & '<39>'
Cheers
Bruce
Logged
Print
Pages: [
1
]
« previous
next »
NetTalk Central
»
NetTalk Web Server
»
Web Server - Ask For Help
»
TPS Table with 357,899 records - times out