Tim

I initially made a mistake and had the server set with Buffered file IO set on but in the client application I had it set off. I was running a test with lots of records being created. One table (People) after the first 30k records was taking between 1 & 3 seconds per record inserted. There's a chunk of code to make sure the _Name & _QuickName fields are unique which will account for some of the slowness. I decided to stop the application, disable the buffering and see how that went. That's when I found I'd enabled buffering in a different application client

So I enabled buffering in both server and client and started the application. Three times its bombed with lost server connection.

The connection is being made initially since the database and tables are created, and population of the tables starts.

Both client & server are W7x64 machines and the client was compiled with D2006

Roy




EXECUTE IMMEDIATE 'CREATE TABLE "People"
(
"_ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"_Name" VARCHAR(40) COLLATE "ANSI_CI" NOT NULL,
"_QuickName" VARCHAR(10) COLLATE "ANSI_CI",
"_PW" VARCHAR(60) COLLATE "ANSI_CI",
"_Employment" VARCHAR(15) COLLATE "ANSI_CI" DEFAULT ''Permanent'',
"_Created" DATE DEFAULT CURRENT_DATE,
"_Permissions" VARCHAR(128) COLLATE "ANSI_CI",
CONSTRAINT "PK" PRIMARY KEY ("_ID"),
CONSTRAINT "Name" UNIQUE ("_Name")
ERROR CODE 10001 MESSAGE '''',
CONSTRAINT "StartWithAlpha" CHECK (0=POS(SUBSTR(_Name,1,1),''0123456789''))
ERROR CODE 10001 MESSAGE '''',
CONSTRAINT "Quick" UNIQUE ("_QuickName")
)


MADEXCEPT LOG
date/time          : 2018-04-05, 10:03:31, 185ms
computer name      : OPTIMUS
user name          : Roy Lambert <admin>
registered owner   : Roy Lambert
operating system   : Windows 7 x64 Service Pack 1 build 7601
system language    : English
system up time     : 1 day 2 hours
program up time    : 3 minutes 9 seconds
processors         : 8x Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
physical memory    : 4953/8112 MB (free/total)
free disk space    : (C10.09 GB (Z326.34 GB
display mode       : 1920x1080, 32 bit
process id         : $3014
allocated memory   : 37.64 MB
largest free block : 1.28 GB
executable         : UpSkill.exe
exec. date/time    : 2018-04-05 09:54
compiled with      : Delphi 2006/07
madExcept version  : 4.0.12
callstack crc      : $baa8f10a, $f4e93607, $f0ef7225
exception number   : 1
exception class    : EEDBError
exception message  : ElevateDB Error #1101 The connection to the server at 'Owned' has been lost ('Timed out while receiving stream').

main thread ($b68):
00696a3e +5e6 UpSkill.exe  edbcomps        TEDBSession.InternalConnect
00696167 +023 UpSkill.exe  edbcomps        TEDBSession.SetConnected
00695fda +002 UpSkill.exe  edbcomps        TEDBSession.Open
00697b65 +011 UpSkill.exe  edbcomps        TEDBSession.Execute
006dcd08 +07c UpSkill.exe  Tables   74 +21 Tdm.DataModuleCreate
0048c207 +02b UpSkill.exe  Classes         TDataModule.DoCreate
0048c0b4 +008 UpSkill.exe  Classes         TDataModule.AfterConstruction
004046b1 +01d UpSkill.exe  System   75  +0 @AfterConstruction
0048c094 +128 UpSkill.exe  Classes         TDataModule.Create
77a3e72d +078 ntdll.dll                    RtlAnsiStringToUnicodeString
004e3e85 +031 UpSkill.exe  Forms           TApplication.CreateForm
00851b0b +03f UpSkill.exe  UpSkill  46  +3 initialization
754d33c8 +010 kernel32.dll                 BaseThreadInitThunk

main thread ($b68), inner exception level 1:
>> EEDBException, ElevateDB Error #1101 The connection to the server at 'Owned' has been lost ('Timed out while receiving stream')
00686f4b +09f UpSkill.exe  edbremote        TEDBRemoteSessionManager.CommLostError
006867e1 +349 UpSkill.exe  edbremote        TEDBRemoteSessionManager.Connect
00686071 +005 UpSkill.exe  edbremote        TEDBRemoteSessionManager.InternalOpen
00686101 +031 UpSkill.exe  edbremote        TEDBRemoteSessionManager.Open
006969df +587 UpSkill.exe  edbcomps         TEDBSession.InternalConnect
00696167 +023 UpSkill.exe  edbcomps         TEDBSession.SetConnected
00695fda +002 UpSkill.exe  edbcomps         TEDBSession.Open
00697b65 +011 UpSkill.exe  edbcomps         TEDBSession.Execute
006dcd08 +07c UpSkill.exe  Tables    74 +21 Tdm.DataModuleCreate
0048c207 +02b UpSkill.exe  Classes          TDataModule.DoCreate
0048c0b4 +008 UpSkill.exe  Classes          TDataModule.AfterConstruction
004046b1 +01d UpSkill.exe  System    75  +0 @AfterConstruction
0048c094 +128 UpSkill.exe  Classes          TDataModule.Create
77a3e72d +078 ntdll.dll                     RtlAnsiStringToUnicodeString
004e3e85 +031 UpSkill.exe  Forms            TApplication.CreateForm
00851b0b +03f UpSkill.exe  UpSkill   46  +3 initialization
754d33c8 +010 kernel32.dll                  BaseThreadInitThunk

thread $2694: <priority:-1>
77a2f8ba +0e ntdll.dll                      NtWaitForSingleObject
77480810 +92 KERNELBASE.dll                 WaitForSingleObjectEx
754d118f +3e kernel32.dll                   WaitForSingleObjectEx
754d1143 +0d kernel32.dll                   WaitForSingleObject
005eb37f +0b UpSkill.exe    edbcommon       TEDBEvent.WaitFor
005eb4e8 +0c UpSkill.exe    edbcommon       TEDBTimerThread.Execute
005e8ac9 +25 UpSkill.exe    edbcommon       ThreadProc
00405274 +28 UpSkill.exe    System    75 +0 ThreadWrapper
0046177d +0d UpSkill.exe    madExcept       CallThreadProcSafe
004617e7 +37 UpSkill.exe    madExcept       ThreadExceptFrame
754d33c8 +10 kernel32.dll                   BaseThreadInitThunk
>> created by main thread ($b68) at:
005e8cc4 +14 UpSkill.exe    edbcommon       TEDBThread.Start

thread $34c0:
77a30146 +0e ntdll.dll     NtWaitForMultipleObjects
754d33c8 +10 kernel32.dll  BaseThreadInitThunk

thread $3610: <priority:1>
77a2f942 +0e ntdll.dll              NtRemoveIoCompletion
0046177d +0d UpSkill.exe  madExcept CallThreadProcSafe
004617e7 +37 UpSkill.exe  madExcept ThreadExceptFrame
754d33c8 +10 kernel32.dll           BaseThreadInitThunk
>> created by main thread ($b68) at:
718ba34f +00 mswsock.dll

thread $40c8:
77a31f2f +0b ntdll.dll     NtWaitForWorkViaWorkerFactory
754d33c8 +10 kernel32.dll  BaseThreadInitThunk

thread $40cc:
77a31f2f +0b ntdll.dll     NtWaitForWorkViaWorkerFactory
754d33c8 +10 kernel32.dll  BaseThreadInitThunk

modules:
00400000 UpSkill.exe                       Z:\SkillMatrix\Progs
0f000000 detoured.dll                      C:\Program Files (x86)\NVIDIA Corporation\CoProcManager
61580000 FaultRep.dll   6.1.7601.17514     C:\windows\system32
64710000 HHCtrl.OCX     6.1.7600.16385     C:\windows\system32
6b160000 SHFolder.dll   6.1.7600.16385     C:\windows\system32
6ce10000 aswhookx.dll   18.2.3.24996       C:\Program Files (x86)\AVG\Antivirus
709d0000 winmm.dll      6.1.7601.17514     C:\windows\system32
70fa0000 ntmarta.dll    6.1.7600.16385     C:\windows\system32
71190000 wshtcpip.dll   6.1.7600.16385     C:\windows\System32
71210000 rasadhlp.dll   6.1.7600.16385     C:\windows\system32
713c0000 wshbth.dll     6.1.7601.17514     C:\windows\system32
713d0000 winrnr.dll     6.1.7600.16385     C:\windows\System32
713e0000 pnrpnsp.dll    6.1.7600.16385     C:\windows\system32
71400000 napinsp.dll    6.1.7600.16385     C:\windows\system32
71410000 NLAapi.dll     6.1.7601.17514     C:\windows\system32
718b0000 mswsock.dll    6.1.7601.18254     C:\windows\system32
718f0000 msimg32.dll    6.1.7600.16385     C:\windows\system32
71e00000 comctl32.dll   5.82.7601.17514    C:\windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_ec83dffa859149af
71eb0000 winspool.drv   6.1.7601.17514     C:\windows\system32
72070000 dwmapi.dll     6.1.7600.16385     C:\windows\system32
72090000 uxtheme.dll    6.1.7600.16385     C:\windows\system32
72110000 comctl32.DLL   6.10.7601.17514    C:\windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.17514_none_41e6975e2bd6f2b2
722f0000 nvdxgiwrap.dll 9.18.13.3523       C:\Program Files (x86)\NVIDIA Corporation\CoProcManager
72310000 nvd3d9wrap.dll 9.18.13.3523       C:\Program Files (x86)\NVIDIA Corporation\CoProcManager
72470000 nvinit.dll     9.18.13.3523       C:\Windows\SysWOW64
734f0000 version.dll    6.1.7600.16385     C:\windows\system32
73520000 DNSAPI.dll     6.1.7601.17514     C:\windows\system32
73640000 WINNSI.DLL     6.1.7600.16385     C:\windows\system32
73650000 IPHLPAPI.DLL   6.1.7601.17514     C:\windows\system32
73a60000 wsock32.dll    6.1.7600.16385     C:\windows\system32
751d0000 fwpuclnt.dll   6.1.7601.17514     C:\windows\System32
75210000 WLIDNSP.DLL    7.250.4311.0       C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live
75240000 propsys.dll    7.0.7601.17514     C:\windows\system32
75390000 CRYPTBASE.dll  6.1.7600.16385     C:\windows\syswow64
753a0000 SspiCli.dll    6.1.7601.17514     C:\windows\syswow64
75410000 comdlg32.dll   6.1.7601.17514     C:\windows\syswow64
75490000 CFGMGR32.dll   6.1.7601.17514     C:\windows\syswow64
754c0000 kernel32.dll   6.1.7601.17514     C:\windows\syswow64
75850000 DEVOBJ.dll     6.1.7600.16385     C:\windows\syswow64
75870000 msvcrt.dll     7.0.7600.16385     C:\windows\syswow64
75b10000 LPK.dll        6.1.7600.16385     C:\windows\syswow64
75b20000 SETUPAPI.dll   6.1.7601.17514     C:\windows\syswow64
75d20000 ole32.dll      6.1.7601.17514     C:\windows\syswow64
75e80000 PSAPI.DLL      6.1.7600.16385     C:\windows\syswow64
75e90000 NSI.dll        6.1.7600.16385     C:\windows\syswow64
75eb0000 oleaut32.dll   6.1.7601.17514     C:\windows\syswow64
75f40000 USP10.dll      1.626.7601.17514   C:\windows\syswow64
75fe0000 SHLWAPI.dll    6.1.7601.17514     C:\windows\syswow64
76040000 MSCTF.dll      6.1.7600.16385     C:\windows\syswow64
76110000 WS2_32.dll     6.1.7601.17514     C:\windows\syswow64
76150000 sechost.dll    6.1.7600.16385     C:\windows\SysWOW64
76300000 USER32.dll     6.1.7601.17514     C:\windows\syswow64
76400000 shell32.dll    6.1.7601.17514     C:\windows\syswow64
77050000 WLDAP32.dll    6.1.7601.17514     C:\windows\syswow64
771f0000 IMM32.DLL      6.1.7601.17514     C:\windows\system32
77250000 RPCRT4.dll     6.1.7601.17514     C:\windows\syswow64
77350000 GDI32.dll      6.1.7601.17514     C:\windows\syswow64
773e0000 CLBCatQ.DLL    2001.12.8530.16385 C:\windows\syswow64
77470000 KERNELBASE.dll 6.1.7601.17514     C:\windows\syswow64
774d0000 ADVAPI32.dll   6.1.7601.17514     C:\windows\syswow64
77a10000 ntdll.dll      6.1.7601.17514     C:\windows\SysWOW64

processes:
0000 Idle                   0 0   0
0004 System                 0 0   0
01f8 smss.exe               0 0   0
0290 csrss.exe              0 0   0
0300 wininit.exe            0 0   0
0314 csrss.exe              1 0   0
0340 services.exe           0 0   0
0350 lsass.exe              0 0   0
0358 lsm.exe                0 0   0
03bc svchost.exe            0 0   0
00c4 winlogon.exe           1 0   0
0184 svchost.exe            0 0   0
0230 svchost.exe            0 0   0
02b0 svchost.exe            0 0   0
0248 svchost.exe            0 0   0
0194 svchost.exe            0 0   0
0558 dwm.exe                1 18  2   high
0570 explorer.exe           1 329 214 normal
05c8 svchost.exe            0 0   0
0638 AVGSvc.exe             0 0   0
0640 wlanext.exe            0 0   0
064c conhost.exe            0 0   0
06bc hkcmd.exe              1 9   5   normal
06e4 SynTPEnh.exe           1 89  42  above normal
0740 WrtMon.exe             1 16  14  normal       C:\windows\System32\spool\drivers\x64\3
0790 SynTPHelper.exe        1 9   3   above normal
0798 WrtProc.exe            1 16  15  normal       C:\windows\System32\spool\drivers\x64\3
07b0 AVGUI.exe              1 106 70  normal       C:\Program Files (x86)\AVG\Antivirus
07cc ReflectUI.exe          1 37  13  normal
045c spoolsv.exe            0 0   0
048c taskhost.exe           1 17  17  normal
05ac svchost.exe            0 0   0
0204 TrayStatus.exe         1 736 259 normal
0838 AutoHotkey.exe         1 17  15  normal
088c EvtEng.exe             0 0   0
08e4 RIconMan.exe           0 0   0
0908 NetPerSec.exe          1 18  8   normal       C:\Utilities\NetPerSec
094c HeciServer.exe         0 0   0
0990 MacriumService.exe     0 0   0
09b8 RealTemp.exe           1 20  62  above normal C:\Utilities\RealTemp
0a4c mdm.exe                0 0   0
0a7c ReflectMonitor.exe     1 47  38  normal
0aa8 PowerBiosServer.exe    0 0   0
0b00 PsiService_2.exe       0 0   0
0b1c PsiService_2.exe       0 0   0
0b38 RegSrvc.exe            0 0   0
0b90 TeamViewer_Service.exe 0 0   0
0bd4 ViakaraokeSrv.exe      0 0   0
0630 WLIDSVC.EXE            0 0   0
09c8 ZeroConfigService.exe  0 0   0
08c8 MBAMService.exe        0 0   0
0c48 WLIDSVCM.EXE           0 0   0
0da8 unsecapp.exe           0 0   0
0ee0 WmiPrvSE.exe           0 0   0
0f64 aswidsagenta.exe       0 0   0
1090 svchost.exe            0 0   0
10c0 svchost.exe            0 0   0
10e4 svchost.exe            0 0   0
06a4 mbamtray.exe           1 26  29  normal       C:\Program Files\Malwarebytes\Anti-Malware
0e14 IntelMeFWService.exe   0 0   0
1084 Jhi_service.exe        0 0   0
0ef4 LMS.exe                0 0   0
3bb4 TfR.exe                1 370 271 normal       D:\TfRProgs
39ec XYplorer.exe           1 449 434 normal       C:\Program Files (x86)\XYplorer
3fd4 taskeng.exe            1 9   3   normal
3b84 Maxthon.exe            1 208 78  normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3f00 Maxthon.exe            1 9   28  normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
39c8 Maxthon.exe            1 14  37  normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3b90 Maxthon.exe            1 22  6   normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3dd0 Maxthon.exe            1 327 14  idle         C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3e70 Maxthon.exe            1 9   4   normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3c30 Maxthon.exe            1 9   9   normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3878 Maxthon.exe            1 9   9   normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3c48 Maxthon.exe            1 9   9   idle         C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3014 UpSkill.exe            1 71  41  normal       Z:\SkillMatrix\Progs
3994 Maxthon.exe            1 9   8   idle         C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3690 Maxthon.exe            1 9   8   idle         C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3d38 Maxthon.exe            1 9   9   idle         C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
3eb8 Maxthon.exe            1 9   8   normal       C:\Program Files (x86)\Maxthon5\5.1.4.1700\Bin
39d8 taskhost.exe           0 0   0
3300 UpSkill.exe            1 70  35  normal       Z:\SkillMatrix\Progs

hardware:
+ Batteries
 - Microsoft AC Adapter
 - Microsoft ACPI-Compliant Control Method Battery
 - Microsoft Composite Battery
+ Bluetooth Radios
 - Generic Bluetooth Adapter
 - Microsoft Bluetooth Enumerator
+ Computer
 - ACPI x64-based PC
+ Disk drives
 - Crucial_CT240M500SSD1 ATA Device
 - TOSHIBA MQ01ABD050 ATA Device
+ Display adapters
 - Intel(R) HD Graphics 4600 (driver 9.18.10.3071)
 - NVIDIA GeForce GTX 765M     (driver 9.18.13.3523)
+ DVD/CD-ROM drives
 - HL-DT-ST DVDRAM GT10N ATA Device
+ Human Interface Devices
 - HID-compliant consumer control device
 - HID-compliant consumer control device
 - HID-compliant device
 - HID-compliant device
 - USB Input Device
 - USB Input Device
 - USB Input Device
+ IDE ATA/ATAPI controllers
 - ATA Channel 0
 - ATA Channel 1
 - ATA Channel 2
 - ATA Channel 4
 - Intel(R) 8 Series SATA AHCI Controller - 8C03 (driver 9.4.0.1017)
+ Imaging devices
 - Chicony USB 2.0 Camera
+ Keyboards
 - Standard PS/2 Keyboard
+ Memory technology driver
 - Realtek PCIE CardReader (driver 6.2.9200.27035)
+ Mice and other pointing devices
 - HID-compliant mouse
 - Synaptics PS/2 Port TouchPad (driver 16.3.4.0)
+ Monitors
 - Generic PnP Monitor
+ Network adapters
 - Bluetooth Device (Personal Area Network)
 - Bluetooth Device (RFCOMM Protocol TDI)
 - Intel(R) Centrino(R) Wireless-N 135 (driver 15.11.0.7)
 - Microsoft ISATAP Adapter
 - Microsoft ISATAP Adapter #2
 - Microsoft ISATAP Adapter #3
 - Microsoft ISATAP Adapter #4
 - Microsoft ISATAP Adapter #5
 - Microsoft ISATAP Adapter #6
 - Microsoft Virtual WiFi Miniport Adapter
 - Microsoft Virtual WiFi Miniport Adapter #2
 - Realtek PCIe GBE Family Controller (driver 7.67.1226.2012)
 - Teredo Tunneling Pseudo-Interface
 - VirtualBox Host-Only Ethernet Adapter (driver 5.1.22.0)
 - WAN Miniport (IKEv2)
 - WAN Miniport (IP)
 - WAN Miniport (IPv6)
 - WAN Miniport (L2TP)
 - WAN Miniport (Network Monitor)
 - WAN Miniport (PPPOE)
 - WAN Miniport (PPTP)
 - WAN Miniport (SSTP)
+ Processors
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
 - Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz
+ Sound, video and game controllers
 - NVIDIA Virtual Audio Device (Wave Extensible) (WDM) (driver 1.2.20.0)
 - USB Audio Device
 - VIA High Definition Audio (driver 6.0.10.1800)
+ System devices
 - ACPI Fixed Feature Button
 - ACPI Lid
 - ACPI Power Button
 - ACPI Sleep Button
 - ACPI Thermal Zone
 - Composite Bus Enumerator
 - Direct memory access controller
 - File as Volume Driver
 - High Definition Audio Controller
 - High precision event timer
 - Intel(R) 8 Series/C220 Series PCI Express Root Port #1 - 8C10 (driver 9.4.0.1017)
 - Intel(R) 8 Series/C220 Series PCI Express Root Port #3 - 8C14 (driver 9.4.0.1017)
 - Intel(R) 8 Series/C220 Series PCI Express Root Port #4 - 8C16 (driver 9.4.0.1017)
 - Intel(R) 82802 Firmware Hub Device
 - Intel(R) HM87 LPC Controller - 8C4B (driver 9.4.0.1017)
 - Intel(R) Management Engine Interface  (driver 9.0.0.1287)
 - Intel(R) Xeon(R) processor E3-1200 v3/4th Gen Core processor DRAM Controller - 0C04 (driver 9.4.0.1017)
 - Intel(R) Xeon(R) processor E3-1200 v3/4th Gen Core processor PCI Express x16 Controller - 0C01 (driver 9.4.0.1017)
 - Microsoft ACPI-Compliant Embedded Controller
 - Microsoft ACPI-Compliant System
 - Microsoft System Management BIOS Driver
 - Microsoft Virtual Drive Enumerator Driver
 - Microsoft Windows Management Interface for ACPI
 - Microsoft Windows Management Interface for ACPI
 - Motherboard resources
 - Motherboard resources
 - Motherboard resources
 - Motherboard resources
 - Motherboard resources
 - PCI bus (driver 2.5.0.19)
 - Plug and Play Software Device Enumerator
 - Programmable interrupt controller
 - Synaptics SMBus Driver (driver 16.3.4.0)
 - System board
 - System CMOS/real time clock
 - System timer
 - Terminal Server Keyboard Driver
 - Terminal Server Mouse Driver
 - UMBus Enumerator
 - UMBus Root Bus Enumerator
 - Volume Manager
+ Universal Serial Bus controllers
 - Generic USB Hub
 - Generic USB Hub
 - Generic USB Hub
 - Intel(R) 8 Series/C220 Series USB EHCI #1 - 8C26 (driver 9.4.0.1017)
 - Intel(R) 8 Series/C220 Series USB EHCI #2 - 8C2D (driver 9.4.0.1017)
 - Intel(R) USB 3.0 eXtensible Host Controller (driver 2.5.0.19)
 - Intel(R) USB 3.0 Root Hub (driver 2.5.0.19)
 - USB Composite Device
 - USB Composite Device
 - USB Composite Device
 - USB Root Hub
 - USB Root Hub

cpu registers:
eax = 0296b5b0
ebx = 029442c0
ecx = 0296b5b0
edx = 00686f50
esi = 00686884
edi = 02902c48
eip = 00686f50
esp = 0018fc5c
ebp = 0018fcb8

stack dump:
0018fc5c  50 6f 68 00 de fa ed 0e - 01 00 00 00 07 00 00 00  Poh.............
0018fc6c  70 fc 18 00 50 6f 68 00 - b0 b5 96 02 c0 42 94 02  p...Poh......B..
0018fc7c  84 68 68 00 48 2c 90 02 - b8 fc 18 00 8c fc 18 00  .hh.H,..........
0018fc8c  c0 fc 18 00 2c 4b 40 00 - b8 fc 18 00 00 3b 68 00  ....,K@......;h.
0018fc9c  00 3b 68 00 00 00 00 00 - 00 00 00 00 00 00 00 00  .;h.............
0018fcac  38 10 99 02 84 68 68 00 - 00 00 00 00 f8 fc 18 00  8....hh.........
0018fcbc  e7 67 68 00 cc fc 18 00 - 2c 4b 40 00 f8 fc 18 00  .gh.....,K@.....
0018fccc  d8 fc 18 00 2c 4b 40 00 - f8 fc 18 00 08 fd 18 00  ....,K@.........
0018fcdc  c3 4c 40 00 f8 fc 18 00 - 48 2c 90 02 00 3b 68 00  .L@.....H,...;h.
0018fcec  c0 42 94 02 50 42 9a 02 - c0 42 94 02 24 fd 18 00  .B..PB...B..$...
0018fcfc  76 60 68 00 c0 42 94 02 - 07 61 68 00 30 fd 18 00  v`h..B...ah.0...
0018fd0c  c3 4c 40 00 24 fd 18 00 - 48 2c 90 02 00 3b 68 00  .L@.$...H,...;h.
0018fd1c  c0 42 94 02 c0 42 94 02 - 74 fd 18 00 e2 69 69 00  .B...B..t....ii.
0018fd2c  00 00 00 00 3c fd 18 00 - 84 4b 40 00 74 fd 18 00  ....<....K@.t...
0018fd3c  48 fd 18 00 c3 4c 40 00 - 74 fd 18 00 ac fd 18 00  H....L@.t.......
0018fd4c  2c 4b 40 00 74 fd 18 00 - 48 2c 90 02 d0 dd 88 02  ,K@.t...H,......
0018fd5c  01 2c 90 02 00 00 00 00 - 00 00 00 00 00 00 00 00  .,..............
0018fd6c  00 00 00 00 d0 dd 88 02 - a0 fd 18 00 6c 61 69 00  ............lai.
0018fd7c  00 00 00 00 d0 dd 88 02 - df 5f 69 00 6a 7b 69 00  ........._i.j{i.
0018fd8c  4c cb 6d 00 40 41 94 02 - b8 87 87 02 4c cb 6d 00  L.m.@A......L.m.

disassembling:
[...]
006dccf6      mov     edx, $6dcd98           ; 'CREATE DATABASE "Skills" PATH '
006dccfb      call    -$2d76c4 ($40563c)     ; System.@LStrCat3
006dcd00      mov     edx, [ebp-$c]
006dcd03      xor     ecx, ecx
006dcd05      mov     eax, [ebx+$60]
006dcd08    > call    -$451b9 ($697b54)      ; edbcomps.TEDBSession.Execute
006dcd0d 75   mov     eax, [ebx+$70]
006dcd10      call    -$3c73d ($6a05d8)      ; edbcomps.TEDBScript.ExecScript
006dcd15 76   mov     ecx, [$862838]
006dcd1b      mov     eax, [$862a58]
006dcd20      mov     eax, [eax]
[...]

It seems 4th time lucky - it bombed quickly the other three times but is now still going after 10 minutes

Roy Lambert

Roy,
 Do I need to enable BufferedFileIO on client too ?
 I thought only on server will be enough ...

Thank you

Charalampos



> Do I need to enable BufferedFileIO on client too ?
> I thought only on server will be enough ...

Absolutely no idea. I'm just trying various combinations. So far it seems as though enabling in both server & client has improved speed but I'm only up to c12k people records so far - I'll wait and see how it does overall.

Roy

Roy,

<< I initially made a mistake and had the server set with Buffered file IO set on but in the client application I had it set off. >>

Buffered file I/O is irrelevant with remote sessions and is only useful for the server engine or with an application using the engine in a server environment (application server, etc.).

<< I was running a test with lots of records being created. One table (People) after the first 30k records was taking between 1 & 3 seconds per record inserted. >>

That is way too slow, with or without buffered file I/O - something else is going on here besides the buffered file I/O.

<< So I enabled buffering in both server and client and started the application. Three times its bombed with lost server connection. >>

You're going to need to look at the EDB Server's logged events in order to see if there are any errors in the EDB Server.  The client application information is basically useless for determining why the client isn't connecting properly (or maintaining its connection properly).

Tim Young
Elevate Software
www.elevatesoft.com