bb.donnay-software.com

You configured "Bools as char" in your ODBC data source.

Open 32bit control panel, go to configuration options, first page under "Data Type Options" uncheck "Bools as char"

12GB is no issues as long OS can read data and serve chunks of it to software and not an ancient binaries are used so imho you are pretty safe with CK control. Mind almost all .zip compressor are single thread-single core and many still don't use modern code ; so speed of compression MBps will vary....

Client side with Shell.Application object ; uses Windows OS integrated zip routines ; UTF file naming and UNC support is solid; good UI feedback for end user .

On server side zip from info-zip OSS project.

There is way. Multiple simultaneous processes might be solution as this looks single - threaded - go from one to another and do upload job. So much of CPU and RAM resources are wasted as usual with xbase. Do a dbfupsize config in individual sets for large DBF tables and one for everything small. The...

This. I honestly tried PGDBE but outside some longer testing decided not to use it ; it was slow, limited to single type of DBMS . One of things I missed at that time (just before or around Covid?) was lack of clear info how to to secure PGDBE connect (SSL require and client side security certificat...

You need to have pgdbe server configured properly. Table with 1.5M records is something sql shrugs off easily. But: pgdbe by my account causes additional writes, not only on main table , but on special columns and calls stored procedures all the time for each insert , update, delete . Might be wrong...

Can be done with binaries too.

Just a simple windows 10/11 VM, four cores, networking disabled by hypervisor
Run tests , see results, delete VM.

Simple as pasulj.

SlavkoDam wrote: ↑Sun Oct 27, 2024 11:14 pm

But I will never ever just install and run an EXE I got from someone somewhere.

What do you suggest, how do you want it?

Indeed this looks worrisome. I knew after testing few years ago that performance of out of the box of pgdbe is not that fast, but this is unexpectedly slow. This is read-only performce, correct? CPU and/or network is fully saturated during search? Can you shed a bit more details on size of data /rec...

Yes, you need to use FUNCTION for this Procedures in postgresql are invoked within CALL PROCEDURE, where FUNCTION is within SELECT statement. Procedure cannot return result set, while functions can (multiple too). So procedure is kinda like .exe called from RUN vs regular functions. Also you need po...

newsgroup @alaska was left to its own decade ago; at some times they did not even knew that it was down for weeks at time ... And there is hardly anything about pgdbe on old newsgroup, while "ILX" forum is open only to paying customers apart from 'q&a' section. This is what Pirsig wrote about topic ...