|Subject:||Re: Not quie sure how to do this
|Date:||Mon, 20 Jun 2016 12:35:30 +1000
|From:||Tom Krieg <"tom krieg AT outlook.com">
Oh, and it's a PostgreSQL database. I switched back because the 10GB
restriction on SQL Server Express was a deal breaker as the Address
Database was over 12GB when loaded and indexed. I found an ADO .NET
driver for PostgreSQL and it works exactly like the SQL Server .NET
connection. I'm actually starting to like Visual Studio .NET. Paradox is
a lot easier in so many ways, but when using graphics and modern UI
techniques Paradox is showing its age and obsolescence.
Oh, and Larry, I can use PostgreSQL on Azure. ;-)
On 20/06/2016 11:54 AM, Tom Krieg wrote:
> I joined a couple of fields into a single index and tried your
> suggestion below, and got the query down to 860ms which is more than
> acceptable. Thanks Liz.