PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
Extremely poor MySQL performance issues when using HAdd
Extremely poor MySQL performance issues when using HAdd
Started by Pascal Scheffers, Jun., 30 2004 10:19 AM - 3 replies
Connect yourself…
Pascal Scheffers
#1
Posted on June, 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.
Report
0
0
joe crevino
#2
Posted on June, 30 2004 - 3:27 PM
Have you tried creating a query in windev using the insert format ?
joe
Report
0
0
Pascal Scheffers
#3
Posted on June, 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.
Report
0
0
joe crevino
#4
Posted on June, 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
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text