[Lazarus] Web development and XML database (Mattias)
zeljko at holobit.net
Thu Nov 17 11:32:03 CET 2011
On Thursday 17 of November 2011 11:11:34 Graeme Geldenhuys wrote:
> On 17 November 2011 11:54, <michael.vancanneyt at ....> wrote:
> > I really don't see why you think SQL databases are slow. We have lots of
> > queries running on our system, huge amounts of updates, and Firebird does
> > an extremely good job of it, and we do almost only multi-table select
> > queries. Concurrency is not an issue at all with their
> > multi-generational architecture - no locking is needed.
> And our systems use GUID's [defined as varchar(36)] as primary keys.
> Not the most optimized primary key type, but very suitable for our
> needs. And still our performance on multi-table select queries are
> very fast.
What database do you use ? It is not optimized primary key type (and x50
slower than eg. int) ,but wondering if it's faster than pure varchar(36)
(because of no non-ascii chars in guid) ?
Anyone measured such things ?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Lazarus