[Lazarus] Web development and XML database (Mattias)

zeljko 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.
> +1
> 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...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20111117/fdfb9f6c/attachment-0003.html>

More information about the Lazarus mailing list