GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV
,
WEBDEV
e
WINDEV Mobile
Inicio
|
Mensagens recentes
|
Conecte-se...
|
Disconnect
|
Português
Inicio
→
WINDEV 2024
→
Extremely poor MySQL performance issues when using HAdd
Extremely poor MySQL performance issues when using HAdd
Iniciado por Pascal Scheffers, jun., 30 2004 10:19 AM - 3 respostas
Conecte-se…
Pascal Scheffers
#1
Publicado em junho, 30 2004 - 10:19 AM
Hi,
I have a MySQL database, and I am using the HAdd function to add new records to a table. The table has some char and integer fields and two fields with a unique index.
Adding records get progressively slower and slower - with 100 records is runs at roughly 1000 inserts per minute, at 1000 records in the table it runs at rougly 300 inserts a minute and at 10000 records in the table, it drops to 1 per second...
When I run the same code on a hyper file with the exact same definition it starts out at 1500 record adds a minute, and doesn't slow down a bit.
What is happening? It is not a mysql issue, I think - doing an insert into that table from the mysql> prompt is very very fast. My gut feeling is that the pcsoft mysql driver is loading all rows for a column from the mysql table for each insert.
Is there another function I should use? SQLAdd or something?
- Pascal.
Denunciar
0
0
joe crevino
#2
Publicado em junho, 30 2004 - 3:27 PM
Have you tried creating a query in windev using the insert format ?
joe
Denunciar
0
0
Pascal Scheffers
#3
Publicado em junho, 30 2004 - 5:20 PM
Have you tried creating a query in windev using the insert format ?
joe
Well, not in Windev, but by hand - and that was, like I said, very fast.
If I can't find a solution just write my own HSQLAdd function, which will do just that. Although I'd like to avoid having to handle the various SQL quoting and date/time conversion issues...
- Pascal.
Denunciar
0
0
joe crevino
#4
Publicado em junho, 30 2004 - 5:42 PM
I have found certain issue with mysql and windev. But as you describe hand coding usually is a very easy fix...but not a quick fix
joe
Denunciar
0
0
→ Voltar para WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versões anteriores)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Tipo de Pesquisa
Apenas tópicos
Todas as mensagens
Período de pesquisa
Qualquer momento
Última hora
Últimas 24 horas
Semana passada
Mês passado
Ano passado
Cancelar
Pré-visualização da sua mensagem
Adicionar imagem
Importar uma imagem de uma URL
Enviar uma imagem a partir do seu disco
Deixe um ficheiro ou clique em "Procurar ..."
ou
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto