first off, thank you for having a real conversation.
who knows maybe we can even share knowledge. i can certainly learn alot from you.
seriously, believe it or not, i don't have these performance problems, and imo a few changes can make a huge diff.
for example, i've recently dumped ~15gig, ~40 million records database
went thru the entire database plus saved the data on file in maybe a quarter of an hour.
as a rule of thumb i and non of my customers would except a query that takes more then a couple of minutes.
i would really be interested if you'll let me try having a go at an example that's been giving you trouble.
i agree with you about the spatial indices, if i understood you correctly, and a few others which i've known about for years.
but i don't know if it's such a huge handicap or more of a high end feature. index merges are a very low cost operation.
who knows maybe we can even share knowledge. i can certainly learn alot from you.
seriously, believe it or not, i don't have these performance problems, and imo a few changes can make a huge diff.
for example, i've recently dumped ~15gig, ~40 million records database
went thru the entire database plus saved the data on file in maybe a quarter of an hour.
as a rule of thumb i and non of my customers would except a query that takes more then a couple of minutes.
i would really be interested if you'll let me try having a go at an example that's been giving you trouble.
i agree with you about the spatial indices, if i understood you correctly, and a few others which i've known about for years.
but i don't know if it's such a huge handicap or more of a high end feature. index merges are a very low cost operation.