Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-12-01 19:01, Charlie wrote: FYI, I did more research on this and just never sent in an update. The key point is whether or not the table was opened "EXCLUSIVE" or not. If you open it exclusive, there is a "chance" the memo "block" will be reused (if the new text size is the same or

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 11/30/2016 5:40 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: One thing I put into my design is working with temporary cursors or As I recall, the main reason for memo bloat was caused when saving data. Specifically, if I was editing a memo, then saved it, if the Just an update:

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-11-03 17:31, Charlie wrote: On 11/3/2016 2:24 PM, Gene Wirchenko wrote: [snip] I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? One

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

At 14:06 2016-11-03, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2016-11-03 14:24, Gene Wirchenko wrote: I have a routine that packs and reindexes all of the tables. I have not needed anything more involved. I do see some memo bloat. I have a table that stores configuration

Re: Friday Poll (while dl'ing MS Flash Patch)

At 12:06 2016-11-03, Ted Roche wrote: On Thu, Nov 3, 2016 at 2:10 PM, Gene Wirchenko wrote: > > As possibly the last to answer -- is there a prize? -- let me state > DBFs. Mostly just stirring the pot. There's a wealth of knowledge here. DBFs: 13 MS

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

oluti...@mbsoftwaresolutions.com" <mbsoftwaresoluti...@mbsoftwaresolutions.com> To: ProFox Email List <profox@leafe.com> Sent: Thursday, November 3, 2016 11:14 PM Subject: Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch)) On 201

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-11-03 19:25, Richard Quilhot wrote: Divide the data into smaller DBF's then add code the select the correct small table that needs updating. Not an option at this point. Besides...this table has only ONE memo field. ___ Post Messages to:

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

Divide the data into smaller DBF's then add code the select the correct small table that needs updating. Rick Q quilh...@gmail.com On Thu, Nov 3, 2016 at 2:24 PM, Gene Wirchenko wrote: > At 08:56 2016-11-03, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > >> On

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-11-03 17:31, Charlie wrote: One thing I put into my design is working with temporary cursors or objects (aka from SCATTER MEMO NAME oDataRec). I rarely have user interface objects directly accessing DBFs. I did this years ago with my MBSS framework based upon your ideas when you

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 11/3/2016 2:24 PM, Gene Wirchenko wrote: [snip] I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? One thing I put into my design is working

Re: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-11-03 14:24, Gene Wirchenko wrote: I have a routine that packs and reindexes all of the tables. I have not needed anything more involved. I do see some memo bloat. I have a table that stores configuration data. When packed, the .fpt is 1280 bytes. I see from the latest sent

Re: Friday Poll (while dl'ing MS Flash Patch)

On Thu, Nov 3, 2016 at 2:10 PM, Gene Wirchenko wrote: > > As possibly the last to answer -- is there a prize? -- let me state > DBFs. > Mostly just stirring the pot. There's a wealth of knowledge here. DBFs: 13 MS SQL Server: 8 1 each for everything else: Azure, Excel,

Re: Friday Poll (while dl'ing MS Flash Patch)

At 06:00 2016-10-28, Ted Roche wrote: So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) As possibly the last to answer -- is there a prize? -- let me state DBFs. [snip]

RE: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-11-03 12:14, Kevin J Cully wrote: I created a subclass of the wwMaint.prg and then put that behind an authentication. I then added various PACKing routines: Some pack all tables, others pack the "vulnerable to memo bloat" tables. The problem is getting exclusive access to the tables.

RE: 2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

riday Poll (while dl'ing MS Flash Patch)) On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of

2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit

2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))

On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit

Re: Friday Poll (while dl'ing MS Flash Patch)

On 2016-10-28 10:59, Peter Cushing wrote: __ DBFs Yup - sooner or later we will look to move to SQL but we don't want to rush into things LOL! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Friday Poll (while dl'ing MS Flash Patch)

On 2016-10-28 09:00, Ted Roche wrote: So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) My backend data of choice for MBSS has been MySQL, and then MariaDB since it forked off from MySQL.

Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

You may also consider creating another new account to test everything. Good luck! ;) On Sat, Oct 29, 2016 at 11:01 PM, Kurt @ VR-FX wrote: > Nope re/retent - newly sent also don't show up. > Am sure acct settings R fine - but will Chk tonight! > Thx, -- .~. Might, Courage,

Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

Nope re/retent - newly sent also don't show up. Am sure acct settings R fine - but will Chk tonight! Thx, -K- Sent from my iPhone > On Oct 29, 2016, at 10:01 AM, Man-wai Chang wrote: > > Were those messages marked expired and got deleted automatically? > Check account and

Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

Were those messages marked expired and got deleted automatically? Check account and server settings (Retention Policy)! Or were they saved in a different Sent folder? Again, check account and server settings. On Sat, Oct 29, 2016 at 1:08 AM, Kurt Wendt wrote: > Hate to

SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

, October 28, 2016 12:50 PM To: profoxt...@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch) On 10/28/2016 9:54 AM, Dave Crozier wrote: > M$SQL 2012 > VFP Databases > SQLite How do you like SQLite, Dave? I've downloaded it and planning to start playing with it so I can star

Re: Friday Poll (while dl'ing MS Flash Patch)

On 10/28/2016 9:54 AM, Dave Crozier wrote: M$SQL 2012 VFP Databases SQLite How do you like SQLite, Dave? I've downloaded it and planning to start playing with it so I can start Android programming. ___ Post Messages to: ProFox@leafe.com

Re: Friday Poll (while dl'ing MS Flash Patch)

>> I don't see SQLite mentioned much. > Single user and insecure so that kind of limits real-world usage to phone applications and similar local storage use cases, as far as I can see. You wouldn't be putting a big production database on it. The following from the SQLite email list. Sent from

Re: Friday Poll (while dl'ing MS Flash Patch)

On 10/28/2016 9:00 AM, Ted Roche wrote: So, where's your data stored today? MS Sql, followed by DBF ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Friday Poll (while dl'ing MS Flash Patch)

On Fri, 28 Oct 2016, at 04:20 PM, Ted Roche wrote: > I don't see SQLite mentioned much. Single user and insecure so that kind of limits real-world usage to phone applications and similar local storage use cases, as far as I can see. You wouldn't be putting a big production database on it. --

RE: Friday Poll (while dl'ing MS Flash Patch)

11:00 AM To: profoxt...@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch) On 28/10/2016 14:00, Ted Roche wrote: > So, where's your data stored today? > > __ DBFs Yup - sooner or later we will look to move to SQL but we don't want to rush into things Peter This comm

RE: Friday Poll (while dl'ing MS Flash Patch)

[mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, October 28, 2016 9:01 AM To: profoxt...@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other

RE: Friday Poll (while dl'ing MS Flash Patch)

Ted, We use it to interface onto the Android tablets as it is obviously Android Native. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: 28 October 2016 16:20 To: profox@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch

RE: Friday Poll (while dl'ing MS Flash Patch)

dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering

Re: Friday Poll (while dl'ing MS Flash Patch)

On Fri, Oct 28, 2016 at 9:54 AM, Dave Crozier wrote: > M$SQL 2012 > VFP Databases > SQLite > > Dave > I don't see SQLite mentioned much. I've worked with it in a couple of situations (including a book by Whil Hentzen I edited) but haven't used it in a production system.

Re: Friday Poll (while dl'ing MS Flash Patch)

On 28/10/2016 14:00, Ted Roche wrote: So, where's your data stored today? __ DBFs Yup - sooner or later we will look to move to SQL but we don't want to rush into things Peter This communication is intended for the person or organisation to whom it is addressed. The contents are

Re: Friday Poll (while dl'ing MS Flash Patch)

On 10/28/2016 06:00 AM, Ted Roche wrote: So, where's your data stored today? X_ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to

Re: Friday Poll (while dl'ing MS Flash Patch)

; -Kevin > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche > Sent: Friday, October 28, 2016 9:01 AM > To: profox@leafe.com > Subject: Friday Poll (while dl'ing MS Flash Patch) > > So, where's your data stored today?

RE: Friday Poll (while dl'ing MS Flash Patch)

subjected to the auto-play media. -Kevin -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, October 28, 2016 9:01 AM To: profox@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL

Re: Friday Poll (while dl'ing MS Flash Patch)

DBFs MS Sql Server Ajit Abraham On 28-Oct-16 4:00 PM, Ted Roche wrote: So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for

Re: Friday Poll (while dl'ing MS Flash Patch)

DBFs - I'm old fashioned (and I don't have much data anymore) John Weller 07976 393631 01380 723235 Sent from my iPhone > On 28 Oct 2016, at 14:00, Ted Roche wrote: > > So, where's your data stored today? > > __ DBFs > > __ MS SQL Server > > __ Azure > > __ Postgres >

RE: Friday Poll (while dl'ing MS Flash Patch)

M$SQL 2012 VFP Databases SQLite Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: 28 October 2016 14:01 To: profox@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch) So, where's your data stored today? __ DBFs __ MS SQL

RE: Friday Poll (while dl'ing MS Flash Patch)

dbf --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Friday Poll (while dl'ing MS Flash Patch)

__ Other (please specify) XML files for fitting data that NEVER changes. USA States and Countries are never changing data in my mind and something that is faster to pull off the website file instead of hitting the sql backend for it. I have plenty of others as well that fit our

Re: Friday Poll (while dl'ing MS Flash Patch)

DBFs MSSQL Azure (for testing and playing around) Excel (although I don't use it like a database, due to not being insane) -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Friday Poll (while dl'ing MS Flash Patch)

So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of